QNT Week 1 Solution

Download Category:

QNT_Week_1.zip - (340.1 KB)
[
QNT_Week_1/QNT561.jpg
QNT_Week_1/QNT561.xlsx
QNT_Week_1/QNT561_2.jpg
QNT_Week_1/Question.txt
]

Choose one of the following datasets to complete this assignment:
• Consumer Food

Answer each of the following:

• For each column, identify whether the data is qualitative or quantitative.
• Identify the level of measurement for the data in each column.
• For each column containing quantitative data:

• Calculate the mean and median
• Use the Excel =AVERAGE function to find the mean
• Use the Excel =MEDIAN function to find the median
• Interpret the mean and median in plain non-technical terms

• Calculate the standard deviation and range
• Use the Excel =STDEV.S function to find the standard deviation
• For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel’s =MIN function
• Interpret the standard deviation and range in plain non-technical terms

Write a Review

Get a fresh solution of this question. Ask it now to our experts.
doubt

Ask Your Question

We have verified professionals who are ready to answer your question.

time

Save Time and Money

We choose experts who can quickly answer your question and that suit your budget.

download

Get Your Answer

Your satisfaction is 100% guaranteed. You can keep on asking questions until you get the answer you need.