Reference no: EM132399788
iPhone User Id 101 204 205 405 701 105 98 12 37 55 68 31 90 92 447 778
Price iPhone User Willing to Pay for New Phone $1,150.00 $1,000.00 $1,050.00 $1,400.00 $1,050.00 $1,350.00 $975.00 $1,650.00 $800.00 $900.00 $850.00 $1,200.00 $835.00 $950.00 $1,050.00 $1,150.00
Android User Id 976 890 1 23 35 87 773 345 667 658 894 420 900 921 122 144 156 873 855 621 9 7 55 67 42
Price Android User Willing to Pay for New Phone $850.00 $1,500.00 $750.00 $650.00 $450.00 $400.00 $750.00 $900.00 $750.00 $1,050.00 $900.00 $850.00 $950.00 $850.00 $600.00 $950.00 $1,150.00 $850.00 $900.00 $1,150.00 $1,000.00 $850.00 $800.00 $800.00 $850.00
Part II: To study Android users you collect data on 25 randomly chosen people. See attached data file
d) Compute sample mean and sample standard deviation for Android users (use Excel Functions)
e) Compute 5-number summary for Android users (use Excel Functions)
f) Find the 90% confidence interval for the average phone price that an Android user willing to pay. . Do computation by hand, using Table D. How do you interpret it?