Exam 1 using the excel

1. Retrieve the Data file "LOUD SPEAKER PRICE" from Blackboard/Exam I.

Type your name on the Excel spreadsheet. (1 point) The spreadsheets that don't have the student's name won't be graded. 2. How many variables do you have? (1 point) 3. Classify each variable as Categorical or Quantitative. (2 points) 4. Provide one tabular summary for one variable of choice. (2 points) 5. Construct one graphical summary for one of the variables. (2 points) 6. Construct a Pivot table for two variables. (2 points) Based on the pivot table make an inferential statement about your variables. (1 point) 7. Provide three measures of location for a quantitative variable. (2 points) 8. Interpret each of the three measures of location provided in question # 7. Use units and complete sentences without mathematical jargon. (3 points) 9. Provide two measures of variability for a quantitative variable. (2 points) 10. Find the 65th percentile for the quantitative variable. (1 point) Interpret the value of the 65th percentile found above. Use units and complete sentences without mathematical jargon. (1 point)

A B C D E F G H K L M N O P Q R S Brand and Model Price in $ Accuracy Type BIC America Venturi DV62si 200 91 Shelf Bose 141 100 86 Shelf Bose 201 Series V 220 89 Shelf Bose 301 Series V 330 86 Shelf Bose 601 Series IV 600 84 Floor Bose 701 Series II 700 82 Floor Bose Acoustimass 3 Series IV 300 94 Shelf Bose Acoustimass 5 Series III 600 94 Shelf Boston Acoustics CR75 300 90 Shelf Boston Acoustics CR85 400 86 Shelf Boston Acoustics VR-M50 700 90 Shelf Cambridge Soundworks Model Six 150 89 Shelf Cambridge Soundworks Newton Series ME 300 90 Shelf Cambridge Soundworks Newton Series ME 400 94 Shelf Cerwin Vega E-710 300 90 Floor Jensen Champion Series C-5 180 86 Floor KLH 911B 85 82 Shelf Klipsch Synergy SB-3 Monitor 450 79 Shelf Pioneer S-DF1-K 200 88 Shelf Pioneer S-DF2-K 260 88 Shelf Polk Audio R20 150 83 Shelf Polk Audio R30 300 89 Floor Polk Audio R50 400 84 Floor PSB Image 2B 370 88 Shelf Sony SS-MB350H 100 92 Shelf Sony SS-MF750H 280 91 Floor Sony SS-X30ED 500 83 Shelf