excel
quake
Case1instructions.docxADMN 210 – Dr. Barbara Sirotnik
Case #1 of 3, Summer 2019
It’s time to see how you do with a dataset that is similar to what one would see in “real life.” Of course in “real life” you would have to figure out for yourself what to do with the dataset. I’m going to help you out a bit.
On page 28 – 29 of your text you will find 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.
Following are the instructions for the case. Please do the analyses in Excel and copy and paste your answers to a Word document (so that I can find everything easily). You will need to upload BOTH the completed Word document and the Excel document (so that I can see what you did).
1) Download the file CardioGoodFitness.xlsx to your computer. Don’t try to work on it by just clicking on the file name from Blackboard. You need to save it first.
2) 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 (I’ll do one for you), you would write: “Miles” is ratio since it is numeric.” You need to write a similar statement for each of the variables. NOTE: this is chapter 1 material.
3) 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. NOTE: this is chapter 2 material.
4) 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. NOTE: this is chapter 2 material.
5) Is there a difference in average income for the three treadmill product lines? NOTE: this is chapter 3 material. NOTE: this is chapter 3 material.
6) 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! NOTE: this is chapter 8 material.
