1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 A. On page 2, consider the first five tables. Each is a data set. Answer the following questions for each data set: What type of data is used? (qualitative/quantitative and discrete/continuous?) What graph and/or chart would be useful in describing the data in each table? B. For Table 1: Construct appropriate charts. Describe the data set. Which situation occurs the most often? The least often? What percentage do not have correction? C. For Table 3: Construct three appropriate charts. What is the mean salary? the median? the mode? What is the range? the standard deviation? What are the lower and upper quartiles? Write a paragraph or so to completely describe the starting salaries of these grads. Include a statement about the salary that the new grads should they expect (based on this information.) D. For Table 6: The physical layout of a warehouse must be carefully designed to prevent vehicle congestion and optimize response time. (The layout assumes that vehicles do not block each other when they travel within.) Warehouse operations were simulated; the number of vehicles was varied and the congestion time was recorded. The researchers wanted to investigate the relationship between congestion time and number of vehicles. Construct a scatterplot for the data. Is there a linear relationship between the number of vehicles and the congestion time? What is the equation of the straight line? Identify the slope? Is it positive or negative? Interpret. What is the coefficient of determination? The correlation coefficient? Interpret. Predict the congestion time for 16 vehicles. Page 1 Question Review for Exam 1 Note: The following problems are presented to help you focus on some important concepts. Others that that relate to Chapters 1-7 could be included on E1. Use Excel in finding your solutions. Solutions for A-D are posted in Excel format. Page 2 Table 1 Table 1: Visual Acuity Problem % 27 7 27 39 Vision Problem Category Nearsighted/corrected Nearsighted/uncorrected Farsighted/corrected Farsighted/uncorrected Page 3 Table 2 Table 2: % of Reading Questions Type by Class Question Type Factual Information Opinion Connection Conditional Class 1 28 49 15 8 Page 4 Class 2 23 51 18 8 Table 2 s Type by Class Class 3 15 56 22 7 Page 5 Table 3 Table 3: Starting Salaries of College Grads $30,000 $20,600 $32,400 $14,200 $25,200 $20,400 $30,300 $30,900 $22,800 $24,400 $17,400 $23,200 $15,300 $31,400 $32,700 $26,700 $34,600 $36,700 $22,100 $24,900 $26,600 $43,900 $22,800 $13,200 $20,700 $36,600 $22,800 $15,700 $11,000 $20,500 $25,200 $38,900 $21,500 $37,500 $28,200 $29,400 $20,400 $26,100 $25,600 $23,100 $20,100 $40,500 $16,800 $33,100 $20,000 $28,300 $30,500 $32,100 Page 6 Table 4 Table 4: Retail Prices for a Sample of VCR's 350 170 265 180 190 450 220 300 300 200 210 220 170 207 200 170 340 180 250 320 190 110 230 220 Page 7 Table 5 Table 5: Calories by Brand of Beer (12 oz) Beer Calories Old Milwaukee Stroh Reddog Budweiser Icehouse Molson Ice Michelob Bud Ice Busch Coors Original Gennessee Cream Ale Miller High Life Pabst Blue Ribbon Milwaukee Best Miller Genuine Draft Rolling Rock Michelob Light Bud Light Natural Light Coors Light Miller Light Amstel Light 145 142 147 148 149 155 159 148 143 137 153 143 144 133 143 143 134 110 110 105 96 95 Page 8 Table 6 Table 6 No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Time 0.00 0.00 0.02 0.01 0.01 0.01 0.03 0.03 0.02 0.04 0.04 0.04 0.03 0.04 0.05 Page 9
3#83caff4#9999ff5#c0c0c0 6#ff00007#ff80808#ffcc999#ffd32010# ffff9990001386024075Fals eFalse | | Review for Exam 1 Note: The following problems are presented to help you focus on some important concepts. Others that that relate to Chapters 1-7 could be included on E1. Use Excel in finding your solutions. Solutions for A-D are posted in Excel format. |
| A. On page 2, consider the first five tables. Each is a data set. Answer the following questions for each data set: | |
Q1 | What type of data is used? (qualitative/quantitative and discrete/continuous?) | |
Q2 | What graph and/or chart would be useful in describing the data in each table? | |
| | |
| B. For Table 1: | |
Q3 | Construct appropriate charts. | |
Q4 | Describe the data set. Which situation occurs the most often? The least often? What percentage do not have correction? | |
| | |
| C. For Table 3: | |
Q5 | Construct three appropriate charts. | |
Q6 | What is the mean salary? the median? the mode? | |
Q7 | What is the range? the standard deviation? What are the lower and upper quartiles? | |
Q8 | Write a paragraph or so to completely describe the starting salaries of these grads. Include a statement about the salary that the new grads should they expect (based on this information.) | |
| D. For Table 6: The physical layout of a warehouse must be carefully designed to prevent vehicle congestion and optimize response time. (The layout assumes that vehicles do not block each other when they travel within.) Warehouse operations were simulated; the number of vehicles was varied and the congestion time was recorded. The researchers wanted to investigate the relationship between congestion time and number of vehicles. | |
Q9 | Construct a scatterplot for the data. Is there a linear relationship between the number of vehicles and the congestion time? | |
Q10 | What is the equation of the straight line? Identify the slope? Is it positive or negative? Interpret. | |
Q11 | What is the coefficient of determination? The correlation coefficient? Interpret. | |
Q12 | Predict the congestion time for 16 vehicles. | |
Table 1: Visual Acuity Problem |
Vision Problem Category | % |
Nearsighted/corrected | 27 |
Nearsighted/uncorrected | 7 |
Farsighted/corrected | 27 |
Farsighted/uncorrected | 39 |
Table 2: % of Reading Questions Type by Class |
Question Type | Class 1 | Class 2 | Class 3 |
Factual Information | 28 | 23 | 15 |
Opinion | 49 | 51 | 56 |
Connection | 15 | 18 | 22 |
Conditional | 8 | 8 | 7 |
Table 3: Starting Salaries of College Grads |
30000 | 20600 | 32400 | 14200 |
25200 | 20400 | 30300 | 30900 |
22800 | 24400 | 17400 | 23200 |
15300 | 31400 | 32700 | 26700 |
34600 | 36700 | 22100 | 24900 |
26600 | 43900 | 22800 | 13200 |
20700 | 36600 | 22800 | 15700 |
11000 | 20500 | 25200 | 38900 |
21500 | 37500 | 28200 | 29400 |
20400 | 26100 | 25600 | 23100 |
20100 | 40500 | 16800 | 33100 |
20000 | 28300 | 30500 | 32100 |
| | | |
Table 4: Retail Prices for a Sample of VCR's | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
350 | 170 | 265 | 180 | |
190 | 450 | 220 | 300 | |
300 | 200 | 210 | 220 | |
170 | 207 | 200 | 170 | |
340 | 180 | 250 | 320 | |
190 | 110 | 230 | 220 | |
Table 5: Calories by Brand of Beer (12 oz) |
Beer | Calories |
Old Milwaukee | 145 |
Stroh | 142 |
Reddog | 147 |
Budweiser | 148 |
Icehouse | 149 |
Molson Ice | 155 |
Michelob | 159 |
Bud Ice | 148 |
Busch | 143 |
Coors Original | 137 |
Gennessee Cream Ale | 153 |
Miller High Life | 143 |
Pabst Blue Ribbon | 144 |
Milwaukee Best | 133 |
Miller Genuine Draft | 143 |
Rolling Rock | 143 |
Michelob Light | 134 |
Bud Light | 110 |
Natural Light | 110 |
Coors Light | 105 |
Miller Light | 96 |
Amstel Light | 95 |
Table 6 |
No. |
There are 3 Steps involved in it
Step: 1
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
|