statistics home work

abbdis2008
ExcelProject11.xlsx
Home>Mathematics homework help>Statistics homework help>statistics home work

Instructions

Excel Project #1
General Instructions
1. Responses to each page should be contained within that page.
2. Calculations and responses for labels should be placed in the cell with the orange background.
3. Type your response for interpretations into the cell indicated with the yellow background.
4. Tables and graphs may be placed where you choose, but should NOT be on a separate worksheet (see #1).
5. Calculations and tables must use cell references (i.e., numbers shouldn't simply be typed w/o work or procedures evident)
6. Include appropriate headings for rows and columns in all tables.
7. Include appropriate titles and axis labels for all graphs.
8. Reminder: this is an individual (not group) project.
9. Your completed project must be submitted to Blackboard before 12:00pm on Wednesday June 13. No exceptions.

Page 1

The table below shows data for a sample of 20 different computers sold at Best Buy Answer Questions 1-4
Computer Type Processor Speed Price ($) Customer Satisfaction Variable Descriptions
Asus Power Star 758 Tablet 8.25 506 Dissatisfied Type: the type of computer
Apple iPad Pro Tablet 13.5 1178 Neutral Processor Speed: a measure of the speed of the computer's process (Scale: 1-20)
Apple iPad Tablet 10.2 672 Neutral Price: the price of the computer
Apple Infinity Edge Laptop 9.9 1320 Very Dissatisfied Customer Satisfaction: rating of overall satisfaction with the computer model (Rating values: Very Dissatisfied, Dissatisfied, Neutral, Satisfied, Very Satisfied)
Apple Symmetry Desktop 11.85 1062 Neutral
Dell 72510 Laptop 8.55 714 Neutral
Sony LS4 Tablet 13.2 540 Dissatisfied 1. Label each of the variables based on their Scale of Measurement and whether they are Qualitative or Quantitative.
Sony Y372 Desktop 10.95 1068 Neutral 2. Construct a Frequency table, including the Frequency, Relative Frequency, and Percent Frequency of the different types of computer
Insignia SE200 Laptop 6.3 1182 Very Satisfied 3. Create a pie chart for customer satisfaction indicating the percent frequency of each rating. Include labels on the pie pieces indicating the percent.
Dell STT PRO Gaming 12.75 2160 Very Dissatisfied
Dell M+S Laptop 7.5 756 Satisfied 4. What interpretations can we make regarding customers' satisfaction?
Microsoft SP 75 A/S Desktop 8.7 1170 Neutral
Microsoft SP 20 FE Laptop 11.55 570 Satisfied
Microsoft SP 60 Laptop 12.75 750 Neutral
HP AT3 Desktop 8.1 678 Satisfied
HP CT5 Tablet 13.5 936 Satisfied
HP TT6 Gaming 8.55 942 Neutral
HP Integrity Tablet 12 1206 Very Satisfied
HP H406 Desktop 10.5 450 Neutral
Asus 722 Laptop 12.3 714 Very Satisfied
Scale of Measurement
Qualitative or Quantitative?

Page 2

The table below shows data for various cars sold in the United States Answer Questions 1-3
Car Size Predicted Reliability Price ($) Road-Test Score Cost/Mile
Chevrolet Cruze 1LT (1.4T) Small Sedan 1 28,090 70 0.78 1. Develop a Crosstabs for the data regarding size and prices of different vehicles. Data should include values from 15,000-45,000 with a class size of 10000.
Chevrolet Cruze 1LT (2.3T) Small Sedan 1 30,090 70 0.73
Chevrolet Cruze LS (1.8) Small Sedan 1 21,885 71 0.73 2. Calculate the row percentages for each size of vehicle and calculate the column percentages for each group of vehicle prices.
Chevrolet Cruze LSX (2.3) Small Sedan 1 23,885 71 0.79 3. What interpretations can we make from the crosstabs?
Ford Fiesta SE Small Sedan 2 29,050 60 0.79
Ford Fiesta SEL Small Sedan 2 31,050 60 0.77
Ford Focus SE Small Sedan 2 22,035 68 0.77
Ford Focus SEL Small Sedan 2 24,035 68 0.75
Hyundai Elantra Small Sedan 3 30,790 82 0.75
Hyundai Elantra GLS Small Sedan 4 32,790 82 0.75
Kia Forte Sedan EX Small Sedan 2 23,970 84 0.75
Kia Forte Sedan EXL Small Sedan 3 25,970 84 0.80
Mazda3i Touring Small Sedan 5 30,335 76 0.80
Mazda3s Grand Touring Small Sedan 5 32,335 88 0.83
Mazda3i Touring (manual) Small Sedan 5 23,830 88 0.83
Mazda3s Touring 5-Door (manual) Small Sedan 5 25,830 69 0.71
Nissan Sentra 2.0 SL Small Sedan 3 20,150 69 0.60
Nissan Sentra 2.0 SLT Small Sedan 4 22,150 67 0.60
Toyota Corolla (base, manual) Small Sedan 4 16,419 67 0.57
Toyota Corolla (base, automatic) Small Sedan 3 18,419 61 0.57
Toyota Corolla LE Small Sedan 4 18,404 61 0.47
Toyota Corolla LES Small Sedan 4 20,404 68 0.47
Volkswagen Jetta SE (2.5) Small Sedan 2 20,300 68 0.52
Volkswagen Jetta SE (3.0) Small Sedan 3 22,300 80 0.52
Volkswagen Jetta TDI Small Sedan 3 25,100 80 0.53
Volkswagen GTI Small Sedan 2 27,100 71 0.53
Chevrolet Impala LT (3.6) Family Sedan 3 28,995 63 0.67
Chevrolet Impala LT (4.5) Family Sedan 3 30,995 63 0.67
Chevrolet Malibu LT (4-cyl.) Family Sedan 3 19,998 74 0.57
Chevrolet Malibu XLT (V6) Family Sedan 2 26,115 74 0.57
Chevrolet Malibu LT Family Sedan 3 30,094 83 0.67
Chevrolet Malibu LTZ (V6) Family Sedan 3 32,094 83 0.67
Chrysler 200 Family Sedan 1 20,530 52 0.70
Chrysler 200 Limited (V6) Family Sedan 2 22,530 52 0.70
Ford Fusion Hybrid Family Sedan 4 18,375 84 0.63
Ford Fusion Hybrid XS Family Sedan 3 20,375 84 0.63
Ford Fusion S (4-cyl.) Family Sedan 2 16,595 76 0.57
Ford Fusion SE (4-cyl.) Family Sedan 3 18,595 76 0.57
Ford Fusion SE (V6) Family Sedan 3 20,280 80 0.67
Ford Fusion SEL (V6) Family Sedan 3 22,280 80 0.67
Ford Fusion SE (V6, AWD) Family Sedan 4 18,445 75 0.71
Ford Fusion SEL (V6, AWD) Family Sedan 4 20,445 75 0.71
Honda Accord EX Family Sedan 5 19,040 90 0.67
Honda Accord EX-L (V6) Family Sedan 5 21,040 90 0.67
Honda Accord LX-P (4-cyl.) Family Sedan 4 19,745 80 0.56
Honda Accord Limited Family Sedan 5 21,745 80 0.56
Hyundai Sonata G Family Sedan 3 18,895 89 0.56
Hyundai Sonata GLS (2.4) Family Sedan 3 20,895 89 0.56
Hyundai Sonata Limited (2.0T) Family Sedan 2 28,045 89 0.66
Hyundai Sonata Limited (3.0T) Family Sedan 3 30,045 89 0.66
Kia Optima LX (2.4) Family Sedan 1 27,825 81 0.58
Kia Optima LXS (3.0) Family Sedan 2 29,825 81 0.58
Kia Optima SX (2.0T) Family Sedan 3 32,360 84 0.72
Kia Optima SXT (3.0T) Family Sedan 4 34,360 84 0.72
Mazda6i Sport (4-cyl.) Family Sedan 4 23,625 73 0.58
Mazda6i Sport 5-Door (4-cyl.) Family Sedan 4 25,625 73 0.58
Mazda6s Touring (V6) Family Sedan 4 28,400 81 0.74
Mazda6s Grand Touring (V6) Family Sedan 4 30,400 81 0.74
Nissan Altima 2.5 (4-cyl.) Family Sedan 3 30,055 91 0.59
Nissan Altima 2.5 S (4-cyl.) Family Sedan 4 32,055 91 0.59
Nissan Altima 3.5 SR Family Sedan 4 28,695 93 0.69
Nissan Altima 3.5 SR (V6) Family Sedan 4 30,695 93 0.69
Subaru Legacy 2.5i Family Sedan 4 23,730 83 0.59
Subaru Legacy 2.5i Premium Family Sedan 4 25,730 83 0.59
Subaru Legacy 3.6R Family Sedan 3 21,800 74 0.71
Subaru Legacy 3.6R Limited Family Sedan 3 23,800 74 0.78
Acura TL (premium) Upscale Sedan 5 36,465 71 0.57
Acura TL (base) Upscale Sedan 5 38,465 70 0.57
Acura TSX (4-cyl.) Upscale Sedan 3 29,675 70 0.52
Acura TSX (6-cyl.) Upscale Sedan 4 31,675 74 0.52
Audi A4 Premium Quattro Upscale Sedan 3 35,895 74 0.50
Audi A4 Premium Plus Quattro Upscale Sedan 3 37,895 76 0.50
BMW 328i Upscale Sedan 3 39,175 77 0.57
BMW 335i Upscale Sedan 3 41,175 77 0.57
Buick LaCrosse CXS Upscale Sedan 2 37,555 74 0.44
Buick LaCrosse CXS (V6) Upscale Sedan 2 39,555 74 0.44
Buick Regal CXL (3.0) Upscale Sedan 2 28,840 77 0.47
Buick Regal CXL (2.4) Upscale Sedan 2 30,840 77 0.47
Buick Regal CX Upscale Sedan 2 32,135 79 0.54
Buick Regal CXL (turbo) Upscale Sedan 2 34,135 79 0.54
Ford Taurus Upscale Sedan 3 34,980 73 0.50
Ford Taurus Limited Upscale Sedan 3 36,980 73 0.50
Hyundai Genesis 3.0 Upscale Sedan 3 39,850 92 0.75
Hyundai Genesis 3.8 Upscale Sedan 3 41,850 92 0.75
Infiniti G25 Upscale Sedan 4 34,225 86 0.67
Infiniti G25 Journey Upscale Sedan 4 36,225 86 0.67
Infiniti G37 Upscale Sedan 4 37,225 95 0.76
Infiniti G37 Journey Upscale Sedan 4 39,225 95 0.76
Lexus ES 350 Upscale Sedan 5 38,615 91 0.79
Lexus ES 350 Premium Upscale Sedan 5 40,615 91 0.79
Lexus HS 250h Upscale Sedan 4 38,939 83 0.81
Lexus HS 250h Premium Upscale Sedan 4 40,939 83 0.81
Lexus IS 250 Upscale Sedan 2 33,734 84 0.65
Lexus IS 250 Premium Upscale Sedan 2 35,734 84 0.65
Lincoln MKZ Upscale Sedan 4 37,160 77 0.71
Lincoln MKZ Platinum Upscale Sedan 4 39,160 77 0.71
Mercedes-Benz C300 Sport Upscale Sedan 3 37,325 77 0.78
Mercedes-Benz C300 Luxury Upscale Sedan 3 39,325 77 0.78
Nissan Maxima 3.5 SV Upscale Sedan 3 33,700 83 0.78
Nissan Maxima 3.5 SVT Upscale Sedan 3 35,700 83 0.78
Saab 9-3 2.0T Upscale Sedan 1 31,615 69 0.70
Saab 9-3 3.0T Upscale Sedan 2 33,615 69 0.70
Toyota Avalon Upscale Sedan 3 35,485 86 0.73
Toyota Avalon Limited Upscale Sedan 3 37,485 86 0.73
Volkswagen CC (2.0T) Upscale Sedan 2 32,680 82 0.73
Volkswagen CC Luxury (3.0T) Upscale Sedan 2 34,680 82 0.73
Volvo S60 T5 Upscale Sedan 4 35,100 77 0.76
Volvo S60 T5 AWD Upscale Sedan 4 37,100 77 0.76

Page 3

The following data is based on a sample of 22 professors at St. Mary's University Answer Questions 1-8
Employee ID # Years of Experience Job Satisfaction Rating
22 15 39 1. Determine the mean, median, and mode for Job Satisfaction Rating.
248 25 17 2. Calculate the 25th, 75th, and 95th percentiles for Job Satisfaction Rating.
138 12 45 3. Calculate the interquartile range.
195 15 58 4. Which Job Satisfaction Ratings, if any, would represent outliers based on IQR? Explain.
162 6 55
234 8 60
118 27 39 5. Calculate the standard deviation of Job Satisfaction Rating.
40 30 45 6. Calculate the z-score for a Job Satisfaction Rating of 75.
17 1 81 7. Create a scatter plot with trend line demonstrating the relationship between Years of Experience and Job Satisfaction Rating.
117 3 75 8. Compute the correlation coefficient.
91 13 70
183 5 47
135 18 50
12 2 60
101 32 62
127 18 49
126 4 55
38 26 61
41 32 20
161 23 50
136 19 71
56 10 57
Mean
Median
Mode
25th Percentile
75th Percentile
95th Percentile
IQR
Std. Deviation
z-score
Correlation

Page 4

An analysis of company sales of 1000 homes in previous years produced the following data Answer Questions 1-5
Days Listed Until Sold
Under 30 30-59 60-89 90 or more Total
Initial Asking Price Under $150,000 60 40 15 10 125
$150,000-$199,999 25 120 75 50 270
$200,000-$249,000 75 200 100 115 490
$250,000 or more 20 25 25 45 115
Total 180 385 215 220 1000
1. What is the probability that the initial asking price is less than $250,000?
2. What is the probability a home is listed for at least 60 days before being sold?
3. What is the probability that a home has an asking price less than $250,000 or is listed for at least 60 days (or both occur)?
4. What is the probability that a home has an asking price less than $250,000 and is listed for at least 60 days?
5. Assuming that a contract was just signed to list a home with an initial asking price of less than $250,000, what is the probability that the home will take at least 60 days to sell?