to ross 101 CardioGood Fitness Return to the CardioGood Fitness case first presented on page 33. Using the data stored in CardioGood Fitness : 1. Compute descriptive statistics to create a customer profile for each CardioGood Fitness treadmill product line. ruano 2. Write a report to be presented to the management of CardioGood Fitness, detailing your findings.34 CHAPTER 1 | Defining and Collecting Data particular profile, thus targeting advertising directly to high- in nu potential customers. CardioGood Fitness sells three different lines of tread- tif mills. The TM195 is an entry-level treadmill. It is as depend- able as other models offered by CardioGood Fitness, but with L fewer programs and features. It is suitable for individuals who thrive on minimal programming and the desire for sim- Id plicity to initiate their walk or hike. The TM195 sells for re $1,500. The middle-line TM498 adds to the features of the entry-level model two user programs and up to 15% elevation upgrade. The TM498 is suitable for individuals who are walk- ers at a transitional stage from walking to running or midlevel runners. The TM498 sells for $1,750. The top-of-the-line TM798 is structurally larger and heavier and has more features than the other models. Its unique fea- tures include a bright blue backlit LCD console, quick speed and incline keys, a wireless heart rate monitor with a telemetric chest strap, remote speed and incline controls, and an anatomical figure that specifies which muscles are minimally and maxi- mally activated. This model features a nonfolding platform base that is designed to handle rigorous, frequent running; the TM798 is therefore appealing to someone who is a power walker or a runner. The selling price is $2,500. As a first step, the market research team at AdRight is assigned the task of identifying the profile of the typical cus- tomer for each treadmill product offered by CardioGood Fitness. The market research team decides to investigate whether there are differences across the product lines with respect to customer characteristics. The team decides to collect data on individuals who purchased a treadmill at a CardioGood Fitness retail store during the prior three months. The team decides to use both business transactional data and the results of a personal profile survey that every purchaser completes as their sources of data. The team identifies the following customer variables to study: product purchased- TM195, TM498, or TM798; gender; age, in years; education, in years; relationship status, single or partnered; annual household income ($); mean number of times the customer plans to use the treadmill each week; mean number of miles the customer expects to walk/run each week; and self-rated fitness on a 1-to-5 scale, where 1 is poor shape and 5 is excellent shape. For this set of variables: 1. Which variables in the survey are categorical? 2. Which variables in the survey are numerical? 3. Which variables are discrete numerical variables?CardioGood Fitness W . CardioGood Fitness is a developer of high-quality cardiovascu lar exercise equipment. Its products include treadmills, fitness bikes, elliptical machines, and e-glides. CardioGood Fitness looks to increase the sales of its treadmill products and has hired The AdRight Agency, a small advertising firm, to create and implement an advertising program. The AdRight Agency plans to identify particular market segments that are most likely to buy their clients' goods and services and then locate advertising outlets that will reach that market group. This activity includes collecting data on clients' actual sales and on the customers who make the purchases, with the goal of determining whether there is a distinct profile of the typical customer for a particular prod- uct or service. If a distinct profile emerges, efforts are made to match that profile to advertising outlets known to reflect theMidterm Case Study 1 Chapter 3 CardioGood Fitness page 158. 0 Use Minitab or Excel worksheet \"CardioGood Fitness\" included in the assignment description. 0 If using Mini-tab, then please use MG3.1 procedures and MG3.2 procedures on pages 165-166 to create descriptive statistics for this task. Note: You do NOT need to do the geometric mean part of MG3.1 or z-scores. o If using Excel, then please use EG3.1 and EG3.2 procedures on pages 160-161. I recommend using the Analysis Toolpak instructions for Excel. It is not necessary to obtain PHStat. Note: You do NOT need to do the geometric mean or z-scores. - Place the descriptive statistics in a formatted table and include in managerial report. a You only need to calculate descriptive statistics for Product TM195. Supplemental instructions 0 Create a managerial report (approximately 2 pages of text) using the format and specications contained in the managerial report template included in the assignment description. Important: - Neatness and quality of your work are important. Please use Times New Roman 11-point font. Single space the text. Double space before and after paragraphs and headings. l-inch margins all four sides. Please e-mail me if you having any questions concerning these procedures. C1-T C2 C3-T C4 C5-T C6 C7 C8 C9 Product Age Gender Education Marital St... Usage Fitness Income Miles 1 TM195 18 Male 14 Single 3 A 29562 112 2 TM195 19 Male 15 Single 2 31836 75 19 Female 14 Partnered 4 30699 66 3 TM195 4 TM195 19 Male 12 Single 3 32973 85 5 TM195 20 Male 13 Partnered 4 2 35247 47 6 TM195 20 Female 14 Partnered 3 32973 66 7 TM195 21 Female 14 Partnered 3 35247 75 8 TM195 21 Male 13 Single 3 32973 85 4 9 TM195 21 Male 15 Single 5 35247 141 10 TM195 21 Female 15 Partnered 2 37521 85 11 TM195 22 Male 14 Single 36384 85 TM195 22 Female 14 Partnered 3 2 35247 66 12 13 TM195 22 Female 16 Single 4 36384 75 14 TM195 22 Female 14 Single 3 35247 75 15 TM195 23 Male 16 Partnered 3 38658 47 16 TM195 23 Male 16 Partnered 3 40932 75 17 TM195 23 Female 14 Single 2 34110 103 18 TM195 23 Male 16 Partnered 4 39795 94 113 19 TM195 23 Female 16 Single 4 38658 TM195 15 Partnered 2 2 34110 38 20 23 Female 3 113 21 TM195 23 Male 14 Single 4 38658 23 Male 16 Single 3 94 22 TM195 4 40932C1-T C2 C3-T C4 C5-T C6 C7 C8 C9 Product Age Gender Education Marital St... Usage Fitness Income Miles 23 TM195 24 Female 16 Single 4 3 42069 94 24 TM195 24 Female 16 Partnered 5 44343 188 25 TM195 24 Male 14 Single 2 45480 113 26 TM195 24 Male 13 Partnered N 42069 47 27 TM195 24 Female 16 Single 4 46617 75 28 TM195 25 Female 14 Partnered Co 48891 75 29 TM195 25 Male 14 Partnered N 45480 56 30 TM195 25 Female 14 Partnered N N 53439 47 31 TM195 25 Female 14 Partnered 39795 85 32 TM195 25 Male 16 Single 4 40932 113 33 TM195 25 Female 16 Partnered N N 40932 47 34 TM195 25 Male 16 Single 3 43206 85 35 TM195 26 Female 14 Partnered 4 44343 113 36 TM195 26 Female 16 Partnered 4 52302 113 37 TM195 26 Male 16 Partnered N N 53439 47 38 TM195 26 Male 16 Partnered 51165 85 39 TM195 26 Female 16 Single 36384 66 40 TM195 26 Male 16 Partnered 44343 132 41 TM195 26 Male 16 Single 50028 85 42 TM195 27 Female 14 Partnered 2 45480 66 43 TM195 27 Male 16 Single 4 3 54576 85 44 TM195 27 Female 14 Partnered 2 3 45480 56C1-T C2 C3-T C4 C5-T C6 C7 C8 C9 Product Age Gender Education Marital St... Usage Fitness Income Miles TM195 28 Female 14 Partnered 2 3 46617 56 45 46 TM195 28 Female 16 Partnered 2 3 52302 66 14 Single 3 103 47 TM195 28 Male 52302 48 TM195 28 Female 14 Partnered 3 54576 94 49 TM195 28 Male 14 Single 4 3 54576 113 TM195 28 Female 16 Partnered 51165 56 50 51 TM195 29 Male 18 Partnered 68220 85 N TM195 29 Female 14 Partnered 2 46617 38 52 TM195 29 Female 16 Partnered 4 50028 94 53 54 TM195 30 Male 14 Partnered 4 A 46617 141 55 TM195 30 Male 14 Single 3 54576 85 56 TM195 31 Male 14 Partnered 2 2 54576 47 57 TM195 31 Female 14 Single 2 2 45480 47 TM195 32 Female 14 Single 3 4 46617 113 58 TM195 32 Male 14 Partnered 4 3 52302 85 59 TM195 33 Female 16 Single 2 55713 38 60 16 Partnered 46617 85 61 TM195 33 Female 3 TM195 34 Male 16 Single 4 51165 169 62 63 TM195 34 Female 16 Single 2 2 52302 66 TM195 35 Male 16 Partnered 4 3 48891 85 64 16 Partnered 94 65 TM195 35 Female 3 3 60261 66 TM195 35 Female 18 Single 3 3 67083 85C1-T C2 C3-T C4 C5-T C6 C7 C8 C9 Product Age Gender Education Marital St... Usage Fitness Income Miles 67 TM195 36 Male 12 Single 4 3 44343 94 68 TM195 37 Female 16 Partnered 3 37521 85 69 TM195 38 Male 16 Partnered 3 46617 75 70 TM195 38 Female 14 Partnered N 3 54576 56 71 TM195 38 Male 14 Single N 3 62302 56 72 TM195 38 Male 16 Partnered 56850 75 73 TM195 39 Male 16 Partnered 4 59124 132 74 TM195 40 Male 16 Partnered 61398 66 75 TM195 41 Male 16 Partnered 4 54576 103 76 TM195 43 Male 16 Partnered 3 53439 66 77 TM195 44 Female 16 Single 4 57987 75 78 TM195 46 Female 16 Partnered N 60261 47 79 TM195 47 Male 16 Partnered 4 56850 94 80 TM195 50 Female 16 Partnered 64809 66 81 TM498 19 Male 14 Single 31836 64 82 TM498 20 Male 14 Single N 32973 53 83 TM498 20 Female 14 Partnered 34110 106 84 TM498 20 Male 14 Single 38658 95 85 TM498 21 Female 14 Partnered 34110 212 86 TM498 21 Male 16 Partnered N 2 34110 42 87 TM498 21 Male 12 Partnered N 2 32973 53 88 TM498 23 Male 14 Partnered 3 3 36384 95C1-T C2 C3-T C4 C5-T C6 C7 C8 C9 Product Age Gender Education Marital St... Usage Fitness Income Miles 89 TM498 23 Male 14 Partnered 3 3 38658 85 90 TM498 23 Female 16 Single 3 3 45480 95 91 TM498 23 Male 16 Partnered 4 45480 127 92 TM498 23 Female 16 Partnered 3 N 43206 74 93 TM498 23 Female 14 Single 3 N 40932 53 94 TM498 23 Male 16 Partnered 3 45480 64 95 TM498 24 Female 14 Single 3 2 40932 85 96 TM498 24 Male 14 Single 3 4 48891 106 97 TM498 24 Female 16 Single 3 50028 106 98 TM498 25 Female 14 Partnered N 45480 85 99 TM498 25 Female 14 Single 3 D 43206 127 100 TM498 25 Male 16 Partnered N 2 52302 42 101 TM498 25 Female 14 Partnered 5 47754 106 102 TM498 25 Male 14 Single 3 3 45480 95 103 TM498 25 Female 14 Single N 3 43206 64 104 TM498 25 Male 14 Partnered 4 3 45480 70 105 TM498 25 Male 14 Partnered 3 D 43206 106 TM498 25 Male 16 Partnered N 106 3 50028 53 107 TM498 25 Female 14 Single N 2 45480 42 108 TM498 25 Male 14 Single 4 48891 127 109 TM498 26 Female 16 Partnered 4 3 45480 85 110 TM498 26 Female 16 Single 4 4 50028 127C1-T C2 C3-T C4 C5-T C6 C7 C8 C9 Product Age Gender Education Marital St... Usage Fitness Income Miles 111 TM498 26 Male 16 Single 4 3 51165 106 112 TM498 27 Male 14 Single 4 2 45480 53 113 TM498 29 Female 14 Partnered 3 51165 95 114 TM498 30 Female 14 Single 57987 74 115 TM498 30 Female 13 Single 4 46617 106 116 TM498 31 Male 16 Partnered 52302 95 117 TM498 31 Female 16 Partnered N 51165 64 118 TM498 31 Female 18 Single N 65220 21 119 TM498 32 Male 16 Single 4 60261 127 120 TM498 32 Male 16 Partnered 3 53439 95 121 TM498 33 Male 13 Partnered 4 4 53439 170 122 TM498 33 Female 16 Partnered N 50028 85 123 TM498 33 Male 16 Partnered 51165 95 124 TM498 33 Female 16 Partnered 53439 95 125 TM498 33 Female 18 Single 47754 74 126 TM498 34 Female 16 Partnered 3 64809 95 127 TM498 34 Male 16 Partnered 4 59124 85 128 TM498 34 Male 15 Single 3 3 67083 85 129 TM498 35 Female 14 Partnered 2 52302 53 130 TM498 35 Male 16 Partnered 2 53439 53 131 TM498 35 Female 16 Single 3 N 50028 64 132 TM498 35 Male 16 Partnered 3 3 53439 95C1-T C2 C3-T C4 C5-T C6 C7 C8 C9 Product Age Gender Education Marital St... Usage Fitness Income Miles 133 TM498 37 Female 16 Partnered 2 3 48891 85 134 TM498 38 Female 16 Partnered 4 3 62535 85 135 TM498 38 Male 16 Partnered 3 3 59124 106 136 TM498 40 Female 16 Partnered 3 3 61398 85 137 TM498 40 Female 16 Single 3 3 57987 85 138 TM498 40 Male 16 Partnered 3 3 64809 95 139 TM498 45 Male 16 Partnered N 2 54576 42 140 TM498 48 Male 16 Partnered N 3 57987 64 141 TM798 22 Male 14 Single 4 3 48658 106 142 TM798 22 Male 16 Single 3 5 54781 120 143 TM798 22 Male 18 Single 4 5 48556 200 144 TM798 23 Male 16 Single 4 5 58516 140 145 TM798 23 Female 18 Single 5 4 53536 100 146 TM798 23 Male 16 Single 4 5 48556 100 147 TM798 24 Male 16 Single 4 5 61006 100 148 TM798 24 Male 18 Partnered 4 5 57271 80 149 TM798 24 Female 16 Single 5 52291 200 150 TM798 24 Male 16 Single 5 5 49801 160 151 TM798 25 Male 16 Partnered 4 5 49801 120 152 TM798 25 Male 16 Partnered 4 4 62251 160 153 TM798 25 Female 18 Partnered 5 5 61006 200 154 TM798 25 Male 18 Partnered 4 3 64741 100C1-T C2 C3-T C4 C5-T C6 C7 C8 C9 Product Age Gender Education Marital St... Usage Fitness Income Miles 155 TM798 25 Male 18 Partnered 6 4 70966 180 156 TM798 25 Male 18 Partnered 6 75946 240 157 TM798 25 Male 20 Partnered 4 74701 170 158 TM798 26 Female 21 Single 4 69721 100 159 TM798 26 Male 16 Partnered F 4 64741 180 160 TM798 27 Male 16 Partnered 4 83416 160 161 TM798 27 Male 18 Single 4 88396 100 162 TM798 27 Male 21 Partnered 4 90886 100 163 TM798 28 Female 18 Partnered 6 92131 180 164 TM798 28 Male 18 Partnered 77191 180 165 TM798 28 Male 18 Single 6 88396 150 166 TM798 29 Male 18 Single 52290 180 167 TM798 29 Male 14 Partnered V 85906 300 168 TM798 30 Female 16 Partnered 90886 280 169 TM798 30 Male 18 Partnered 4 103336 160 170 TM798 30 Male 18 Partnered 99601 150 171 TM798 31 Male 16 Partnered 89641 260 172 TM798 33 Female 18 Partnered 4 95866 200 173 TM798 34 Male 16 Single 92131 150 174 TM798 35 Male 16 Partnered 4 92131 360 175 TM798 38 Male 18 Partnered 07 104581 150 176 TM798 40 Male 21 Single 6 5 83416 200\fManagerial Report for TO: Dr. Nelson FROM: DATE: SUBJECT: Problem Statement Statistical Results Conclusion Works cited