Excel Question

Instruction:

Following are the instructions for the case. Please do the analyses in Excel and copy and paste your answers to a Word document.

1) Indicate the level of measurement for each of the variables in the data set, and briefly justify your choice. In other words, is each of the variables nominal, ordinal, interval, or ratio? For example, you would write: “Miles” is ratio since it is numeric.” You need to write a similar statement for each of the variables.

2) Suppose the company wishes to create a customer profile. Let’s start with the variable gender. Form a frequency distribution and relative frequency distribution for the gender of the 180 customers. Construct the appropriate graph for the data and interpret in practical form. That is, describe the gender profile of the people that buy a treadmill from this company.

3) Now consider the variable income. Form a frequency distribution and relative frequency distribution for income of the 180 customers. Construct the appropriate graph for the data and interpret in practical form.

4) Is there a difference in average income for the three treadmill product lines?

5) Years ago the company did an analysis of their entire customer base and found that the average income for their customers was $50,000. They believe that incomes of their current customers are significantly higher than that. Construct a 95% confidence interval for income for the customer group as a whole. Based on this interval, can the company assume that incomes have gone up? Justify your answer!

There are the description of a data set for a company that sells three different levels of treadmills (as well as other exercise equipment). I’m going to use this data set to review a bit of the material from previous modules, and look toward future material.