Three part question. Show all work. Question 1 (15 points) Here is a table of pu

Question

Three part question. Show all work.

Question 1 (15 points) Here is a table of purchasers of Ford cars. Purchasers of Ford Cars e Genderl-Income-l car Typelobservationl-Age- Gender-Income M IS 71-1 Fusion FS 98,000 Escape 21 54,000 F S 101,000 Escape M S 37,000 Fusion M 103,000 Mustang M S 112,000 Escape F 57,000 Explorer M $ 111,000 Mustang M $ 37,000 Escape 23 24 51 45 -25 26 726 F S 43,000 Explorer 27 |$ 71.00 | Fusion M S 109,000 Mustang F S 85,000 Escape M 109,000 Mustan F S 93,000 Escape M S 102,000 Explorer M $ 59,000 Fusion Fs 103,000 Mustang M S 80,000 Mustang F 108,000 Escape M $ 58,000 Explorer F 38,000 Fusion F $ 120,000 Mustang 47 29 10 FS 104,000 Explorer 45 11 45 F s 116,000 Fusion 31 M S 103,000 Mustang M $ 121,000 Escape F S 57,000 Explorer 32 13 27 14 43 M 83,000 Musta 35 25 16 | 27 | F IS 73,001 Escape F 62,000 Explorer M S 43,000 Escape M S 38,000 Explorer F 116,000 Mustang M S 105,000 Escape 17 25 37 2 s 44,000 Fusion t 19 M $ 70,000 Mustan S 113,000 Escape F95,00 Fusion (5 points) Based on Age Group, create four frequency tables with six classes, one for each Car Type. The tables should have frequencies, relative frequencies, midpoints and cumulative frequencies (5 points) Fill in the table below based on the raw data above. a. b.

Explanation / Answer

(a) If you load the above data into excel, and use the frequency() function with Age Group and Car type as input parameters, you will get the frequency of the different car typeswithin the different age groups you can comput the frequencies, relative frequencies and cumulative frequencies by using simple sum and difference functions

(b) Again once the data is loaded into excel as a table there are set of functions you can use to compute all of the given values, they are given as below. Pass the entire columns of Age and Income is inputs to these functions

Miminimum : Min(), Maximum: Max(), Mean: mean(), Median: Median() , Mode: Mode(), Variance: Var.S()

Std.Dev: STDEV.S() , Coeff of variation : STDEV.S() / Mean()

You will get all of the values you need

(c) Prob that given a purchaser is female they will buy a fusion = Total number of fusions purchsed by females / total number of females

Prob that given that someone bought an escape they make 79000$ or more = Total number of cases in Escape Purchases which yielded 79000$ or more / Total number of Escape purchases

Finding these numbers and dividing them appropriately will yield the probabilities.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.