Quantitative Assignment- (Statistics Assignment)
Mr. Someone
quantitative_assignment-_statistics.xlsxSaving-Spending
| Up to 12 points | ||
| 1. Researchers are interested in whether the percentage of savings for U.S. individuals is correlated | ||
| with their disposable income. They were able to obtain data from January 2000 through February 2015 | ||
| They want to know if the more disposable income people have the more they will save. | ||
| A. Analyze the data to see if there is significant correlation between the two variables. Be sure you do the right tests | ||
| B. Identify the dependent and independent variables | ||
| C. Be sure to highlight the statistical results you used to make your decision and explain your results in words and numbers | ||
| D. Be sure to interpret the results in words and tie back to what the researchers want to know. | ||
| DATE | % Saving Rate | Disposable Income |
| 2000-01-01 | 4.7 | 8,744.80 |
| 2000-02-01 | 4.2 | 8,778.70 |
| 2000-03-01 | 3.9 | 8,800.60 |
| 2000-04-01 | 4.4 | 8,836.90 |
| 2000-05-01 | 4.2 | 8,869.80 |
| 2000-06-01 | 4.2 | 8,890.20 |
| 2000-07-01 | 4.6 | 8,937.10 |
| 2000-08-01 | 4.6 | 8,985.20 |
| 2000-09-01 | 3.8 | 8,985.50 |
| 2000-10-01 | 4.0 | 9,000.00 |
| 2000-11-01 | 3.8 | 8,994.00 |
| 2000-12-01 | 3.5 | 9,004.60 |
| 2001-01-01 | 4.0 | 9,054.50 |
| 2001-02-01 | 4.1 | 9,073.00 |
| 2001-03-01 | 4.5 | 9,101.30 |
| 2001-04-01 | 4.3 | 9,080.80 |
| 2001-05-01 | 3.7 | 9,061.70 |
| 2001-06-01 | 3.7 | 9,062.40 |
| 2001-07-01 | 5.0 | 9,198.40 |
| 2001-08-01 | 6.1 | 9,359.00 |
| 2001-09-01 | 6.3 | 9,290.50 |
| 2001-10-01 | 2.7 | 9,145.70 |
| 2001-11-01 | 3.4 | 9,167.50 |
| 2001-12-01 | 3.8 | 9,190.30 |
| 2002-01-01 | 5.6 | 9,385.70 |
| 2002-02-01 | 5.3 | 9,395.50 |
| 2002-03-01 | 5.3 | 9,391.30 |
| 2002-04-01 | 5.1 | 9,417.90 |
| 2002-05-01 | 5.6 | 9,438.50 |
| 2002-06-01 | 5.4 | 9,459.00 |
| 2002-07-01 | 4.6 | 9,429.70 |
| 2002-08-01 | 4.4 | 9,422.00 |
| 2002-09-01 | 4.9 | 9,427.10 |
| 2002-10-01 | 4.7 | 9,448.30 |
| 2002-11-01 | 4.7 | 9,469.50 |
| 2002-12-01 | 4.5 | 9,497.00 |
| 2003-01-01 | 4.5 | 9,499.70 |
| 2003-02-01 | 4.7 | 9,480.20 |
| 2003-03-01 | 4.6 | 9,513.80 |
| 2003-04-01 | 4.6 | 9,575.10 |
| 2003-05-01 | 5.1 | 9,649.50 |
| 2003-06-01 | 4.9 | 9,682.20 |
| 2003-07-01 | 5.5 | 9,791.00 |
| 2003-08-01 | 5.3 | 9,851.70 |
| 2003-09-01 | 4.5 | 9,738.00 |
| 2003-10-01 | 4.6 | 9,779.60 |
| 2003-11-01 | 4.7 | 9,851.40 |
| 2003-12-01 | 4.8 | 9,868.10 |
| 2004-01-01 | 4.5 | 9,878.90 |
| 2004-02-01 | 4.5 | 9,899.70 |
| 2004-03-01 | 4.5 | 9,935.50 |
| 2004-04-01 | 4.7 | 9,968.10 |
| 2004-05-01 | 4.7 | 10,019.20 |
| 2004-06-01 | 5.0 | 10,019.50 |
| 2004-07-01 | 4.5 | 10,035.40 |
| 2004-08-01 | 4.6 | 10,064.70 |
| 2004-09-01 | 3.9 | 10,064.90 |
| 2004-10-01 | 3.8 | 10,074.00 |
| 2004-11-01 | 3.4 | 10,050.20 |
| 2004-12-01 | 6.3 | 10,417.50 |
| 2005-01-01 | 2.9 | 10,069.30 |
| 2005-02-01 | 2.7 | 10,073.50 |
| 2005-03-01 | 2.7 | 10,104.80 |
| 2005-04-01 | 2.1 | 10,124.50 |
| 2005-05-01 | 3.0 | 10,166.40 |
| 2005-06-01 | 2.2 | 10,195.80 |
| 2005-07-01 | 1.9 | 10,221.50 |
| 2005-08-01 | 2.4 | 10,236.90 |
| 2005-09-01 | 2.3 | 10,184.60 |
| 2005-10-01 | 2.6 | 10,233.70 |
| 2005-11-01 | 2.7 | 10,303.90 |
| 2005-12-01 | 2.8 | 10,358.70 |
| 2006-01-01 | 3.7 | 10,497.70 |
| 2006-02-01 | 3.8 | 10,542.50 |
| 2006-03-01 | 3.7 | 10,561.70 |
| 2006-04-01 | 3.4 | 10,548.20 |
| 2006-05-01 | 3.2 | 10,538.90 |
| 2006-06-01 | 3.4 | 10,562.30 |
| 2006-07-01 | 2.9 | 10,559.50 |
| 2006-08-01 | 3.0 | 10,557.60 |
| 2006-09-01 | 3.0 | 10,622.60 |
| 2006-10-01 | 3.1 | 10,683.80 |
| 2006-11-01 | 3.2 | 10,721.60 |
| 2006-12-01 | 3.0 | 10,749.60 |
| 2007-01-01 | 3.0 | 10,759.00 |
| 2007-02-01 | 3.3 | 10,787.10 |
| 2007-03-01 | 3.6 | 10,819.70 |
| 2007-04-01 | 3.2 | 10,817.20 |
| 2007-05-01 | 3.0 | 10,811.90 |
| 2007-06-01 | 2.8 | 10,799.50 |
| 2007-07-01 | 2.8 | 10,824.30 |
| 2007-08-01 | 2.6 | 10,830.80 |
| 2007-09-01 | 2.8 | 10,858.40 |
| 2007-10-01 | 2.8 | 10,838.60 |
| 2007-11-01 | 2.5 | 10,828.10 |
| 2007-12-01 | 3.0 | 10,874.10 |
| 2008-01-01 | 3.4 | 10,904.70 |
| 2008-02-01 | 3.9 | 10,923.90 |
| 2008-03-01 | 4.0 | 10,946.90 |
| 2008-04-01 | 3.5 | 10,906.10 |
| 2008-05-01 | 7.9 | 11,430.90 |
| 2008-06-01 | 5.6 | 11,129.10 |
| 2008-07-01 | 4.4 | 10,953.60 |
| 2008-08-01 | 3.7 | 10,865.90 |
| 2008-09-01 | 4.4 | 10,878.20 |
| 2008-10-01 | 5.4 | 10,932.30 |
| 2008-11-01 | 6.3 | 11,008.10 |
| 2008-12-01 | 6.5 | 10,968.40 |
| 2009-01-01 | 6.5 | 11,014.40 |
| 2009-02-01 | 5.9 | 10,915.30 |
| 2009-03-01 | 6.1 | 10,915.90 |
| 2009-04-01 | 6.7 | 10,975.70 |
| 2009-05-01 | 8.1 | 11,146.50 |
| 2009-06-01 | 6.7 | 10,957.30 |
| 2009-07-01 | 6.0 | 10,918.60 |
| 2009-08-01 | 4.9 | 10,891.60 |
| 2009-09-01 | 5.9 | 10,906.30 |
| 2009-10-01 | 5.4 | 10,861.60 |
| 2009-11-01 | 5.7 | 10,886.90 |
| 2009-12-01 | 5.7 | 10,924.70 |
| 2010-01-01 | 5.6 | 10,906.70 |
| 2010-02-01 | 5.2 | 10,887.50 |
| 2010-03-01 | 5.0 | 10,912.00 |
| 2010-04-01 | 5.6 | 10,993.20 |
| 2010-05-01 | 6.0 | 11,067.00 |
| 2010-06-01 | 5.9 | 11,071.30 |
| 2010-07-01 | 5.9 | 11,080.50 |
| 2010-08-01 | 5.8 | 11,114.70 |
| 2010-09-01 | 5.6 | 11,101.20 |
| 2010-10-01 | 5.4 | 11,128.30 |
| 2010-11-01 | 5.3 | 11,160.80 |
| 2010-12-01 | 5.9 | 11,239.00 |
| 2011-01-01 | 6.2 | 11,297.40 |
| 2011-02-01 | 6.4 | 11,329.00 |
| 2011-03-01 | 6.0 | 11,312.40 |
| 2011-04-01 | 5.9 | 11,282.80 |
| 2011-05-01 | 5.9 | 11,277.10 |
| 2011-06-01 | 6.1 | 11,325.80 |
| 2011-07-01 | 6.3 | 11,371.20 |
| 2011-08-01 | 6.2 | 11,363.50 |
| 2011-09-01 | 5.7 | 11,330.80 |
| 2011-10-01 | 5.5 | 11,340.80 |
| 2011-11-01 | 5.6 | 11,329.30 |
| 2011-12-01 | 6.4 | 11,416.00 |
| 2012-01-01 | 6.6 | 11,500.30 |
| 2012-02-01 | 6.7 | 11,562.50 |
| 2012-03-01 | 6.9 | 11,586.80 |
| 2012-04-01 | 7.0 | 11,609.40 |
| 2012-05-01 | 7.0 | 11,611.60 |
| 2012-06-01 | 7.1 | 11,627.60 |
| 2012-07-01 | 6.6 | 11,597.10 |
| 2012-08-01 | 6.4 | 11,576.60 |
| 2012-09-01 | 6.5 | 11,638.50 |
| 2012-10-01 | 7.1 | 11,709.10 |
| 2012-11-01 | 8.2 | 11,877.20 |
| 2012-12-01 | 10.5 | 12,214.10 |
| 2013-01-01 | 4.5 | 11,487.60 |
| 2013-02-01 | 4.7 | 11,543.50 |
| 2013-03-01 | 4.9 | 11,584.70 |
| 2013-04-01 | 5.1 | 11,612.50 |
| 2013-05-01 | 5.2 | 11,653.50 |
| 2013-06-01 | 5.3 | 11,675.10 |
| 2013-07-01 | 5.1 | 11,665.60 |
| 2013-08-01 | 5.3 | 11,709.30 |
| 2013-09-01 | 5.2 | 11,742.70 |
| 2013-10-01 | 4.7 | 11,713.00 |
| 2013-11-01 | 4.3 | 11,725.60 |
| 2013-12-01 | 4.1 | 11,696.60 |
| 2014-01-01 | 4.9 | 11,753.20 |
| 2014-02-01 | 5.0 | 11,811.50 |
| 2014-03-01 | 4.8 | 11,865.40 |
| 2014-04-01 | 5.0 | 11,879.50 |
| 2014-05-01 | 5.1 | 11,897.70 |
| 2014-06-01 | 5.1 | 11,923.80 |
| 2014-07-01 | 5.1 | 11,939.40 |
| 2014-08-01 | 4.7 | 11,981.70 |
| 2014-09-01 | 4.6 | 11,989.80 |
| 2014-10-01 | 4.5 | 12,017.70 |
| 2014-11-01 | 4.4 | 12,074.00 |
| 2014-12-01 | 4.9 | 12,139.30 |
| 2015-01-01 | 5.5 | 12,249.10 |
| 2015-02-01 | 5.8 | 12,278.10 |
on-line vs lecture
| up to 15 points | ||||||||
| 2. One professor was interested in evaluating the overall performance of students in online sections | ||||||||
| He wanted to know if students in an online section would do as well as students in a face-to-face section. So one semester | ||||||||
| he has the same class but one class was delivered in an online format and one section was delivered face-to-face and it served as a control section | ||||||||
| The grades of each section are listed below, | ||||||||
| with 4.0 = A down to 0.0 = F. | ||||||||
| A. Write out in words the Null and Alternative hypotheses for this situation | ||||||||
| B. Create a histogram of each class using the bins below. | ||||||||
| C. What is the correct statistical test to use - satistically determine if there is a difference between the delivery methods. | ||||||||
| D. Perform the correct Test, highlight the result you use to interpret the test and report in words your conclusion about the hypothesis | ||||||||
| E How do these results compare? Practically, what is happening in the classes? | ||||||||
| On-line | Lecture | Bins | ||||||
| 4.0 | 2.0 | 0.0 | ||||||
| 4.0 | 3.0 | 0.3 | ||||||
| 2.3 | 2.3 | 0.7 | ||||||
| 4.0 | 3.0 | 1.0 | ||||||
| 4.0 | 3.3 | 1.3 | ||||||
| 3.7 | 3.0 | 1.7 | ||||||
| 4.0 | 1.0 | 2.0 | ||||||
| 0.3 | 4.0 | 2.3 | ||||||
| 0.0 | 4.0 | 2.7 | ||||||
| 4.0 | 3.7 | 3.0 | ||||||
| 4.0 | 3.0 | 3.3 | ||||||
| 2.0 | 4.0 | 3.7 | ||||||
| 3.3 | 1.0 | 4.0 | ||||||
| 4.0 | 2.0 | |||||||
| 2.0 | 3.0 | |||||||
| 4.0 | 3.0 | |||||||
| 3.7 | 1.0 | |||||||
| 3.3 | 2.0 | |||||||
| 3.0 | 2.0 | |||||||
| 2.0 | 1.3 | |||||||
| 4.0 | 4.0 | |||||||
| 0.0 | 4.0 | |||||||
| 3.7 | 4.0 | |||||||
| 0.0 | 3.7 | |||||||
| 3.0 | 3.3 | |||||||
| 0.3 | 1.7 | |||||||
| 3.0 | 3.7 | |||||||
| 3.3 | 3.0 | |||||||
| 3.7 | 4.0 | |||||||
| 3.3 | 1.7 | |||||||
| 4.0 | 2.5 | |||||||
| 3.0 | 3.2 | |||||||
| 4.0 | 2.9 | |||||||
| 4.0 | 3.5 | |||||||
| 4.0 | 3.7 | |||||||
| 4.0 | 3.5 | |||||||
| 3.0 | 3.6 | |||||||
| 0.0 | 3.0 | |||||||
| 3.3 | 1.5 | |||||||
| 3.7 | 2.8 | |||||||
| 0.0 | ||||||||
| 2.3 | ||||||||
| 2.7 | ||||||||
| 3.0 | ||||||||
| 4.0 | ||||||||
| 4.0 | ||||||||
| 4.0 | ||||||||
| 0.0 | ||||||||
| 0.0 | ||||||||
| 3.3 | ||||||||
| 4.0 | ||||||||
Defects & training
| up to 15 points | ||||||||
| 3. A company was concerned about the increasing number of defects and went to their training staff and had them develop a training program | ||||||||
| to reinforce the proper way to assemble the gearmotors. The training program was given to the first shift but not the second shift. You are given the defects per operator | ||||||||
| The number of monthly defects per operator was taken foro the month before the training and the month after the training. | ||||||||
| Statistics were gathered from the shift who was training as well as the shift that was not trained. Did the training significantly reduce the number of defects? | ||||||||
| A. Write out the null and alternative hypotheses and interpret your results in terms of the hyptheses | ||||||||
| B. Perform the correct statistical test | ||||||||
| C. Highlight the result you use to interpret the test and report in words your conclusion about the hypothesis | ||||||||
| In addition you are to make specific recommendations to the training staff with regard to the future of the training program they developed. | ||||||||
| You are to be professional in what you report and recommend to the training staff. | ||||||||
| There is a "trick" to this one -- think carefully before running the stats test - | ||||||||
| First shift defects | Second shift defects | |||||||
| Operator | Before | After | Operator | Before | After | |||
| 1 | 3 | 2 | 13 | 6 | 5 | |||
| 2 | 4 | 0 | 14 | 7 | 6 | |||
| 3 | 2 | 0 | 15 | 3 | 5 | |||
| 4 | 1 | 1 | 16 | 4 | 3 | |||
| 5 | 0 | 0 | 17 | 2 | 4 | |||
| 6 | 2 | 3 | 18 | 5 | 3 | |||
| 7 | 3 | 1 | 19 | 4 | 2 | |||
| 8 | 2 | 1 | 20 | 2 | 1 | |||
| 9 | 2 | 1 | 21 | 2 | 1 | |||
| 10 | 1 | 0 | 22 | 6 | 3 | |||
| 11 | 0 | 0 | 23 | 3 | 2 | |||
| 12 | 5 | 1 | 24 | 1 | 2 | |||
Season Tickets
| up to 12 points | |||||
| 4. The general manager of a basketball team wants to know if there is a significant correlation between the number of. | |||||
| season ticket sales and the percentage of games won. | |||||
| A. Analyze the data to determine the correlation and to see if there is significant correlation between the two variables. | |||||
| B. Identify the dependent and independent variables | |||||
| C. Be sure to highlight the statistical results you used to make your decision | |||||
| D. Write out your results in words | |||||
| Year | Sales | ||||
| Season Tickets | % Games Won | ||||
| 2002 | 4995 | 40 | |||
| 2003 | 8599 | 54 | |||
| 2004 | 8479 | 55 | |||
| 2005 | 8419 | 58 | |||
| 2006 | 10253 | 63 | |||
| 2007 | 12457 | 75 | |||
| 2008 | 13285 | 48 | |||
| 2009 | 14177 | 54 | |||
| 2010 | 15730 | 63 | |||
| 2011 | 15805 | 70 | |||
Sales Training
| up to 10 points | ||||||
| 5. A sales Force received some sales skill training. Are the before/after mean scores for salespeople's job performance | ||||||
| Statistically significant at the 0.05 level? The results from a sample of employees are as listed below. | ||||||
| The Salespeople were given a skills test before and after the training. | ||||||
| A. Write out the null and alternative hypotheses and interpret your results in terms of the hyptheses | ||||||
| B. What is the correct statistical Test to Use | ||||||
| C. Perform the correct Test, highlight the result you use to interpret the test and report in words your conclusion about the hypothesis | ||||||
| There is a "trick" to this one -- think carefully before running the stats test - | ||||||
| Performance | Performance | |||||
| Name | Before | After | ||||
| Ed | 4.84 | 5.43 | ||||
| Mark | 5.24 | 5.51 | ||||
| Jason | 5.37 | 5.42 | ||||
| Raj | 3.69 | 4.50 | ||||
| Heidi | 5.95 | 5.90 | ||||
| Donna | 4.75 | 5.25 | ||||
| Rob | 3.90 | 4.50 | ||||
| Kathy | 4.00 | 5.00 | ||||
| Susie | 4.67 | 4.50 | ||||
| Ron | 4.95 | 4.40 | ||||
| Jen | 4.00 | 5.95 | ||||
| Matt | 3.75 | 3.50 | ||||
| Doug | 3.85 | 4.00 | ||||
| Bob | 5.00 | 4.10 | ||||
washers
| up to 11 points | ||||||
| 6. A cell phone manufacturer receives washers from their supplier in boxes of 1000. | ||||||
| After running short of washers on the line, they wonder if they are receiving the | ||||||
| full quantities ordered. Forty-five boxes are weighed and counted, with results below. | ||||||
| A. What is the average number of washers per box? | ||||||
| B. What is the standard deviation and range on the number of washers per box? | ||||||
| C. Find the confidence interval on number of washers per box. | ||||||
| D. Can they statistically prove that they are being shorted washers? | ||||||
| Box | Washers | |||||
| 1 | 969 | |||||
| 2 | 994 | |||||
| 3 | 983 | |||||
| 4 | 1015 | |||||
| 5 | 994 | |||||
| 6 | 1030 | |||||
| 7 | 980 | |||||
| 8 | 996 | |||||
| 9 | 1011 | |||||
| 10 | 1014 | |||||
| 11 | 964 | |||||
| 12 | 999 | |||||
| 13 | 986 | |||||
| 14 | 1003 | |||||
| 15 | 981 | |||||
| 16 | 962 | |||||
| 17 | 1000 | |||||
| 18 | 1005 | |||||
| 19 | 981 | |||||
| 20 | 998 | |||||
| 21 | 980 | |||||
| 22 | 1007 | |||||
| 23 | 990 | |||||
| 24 | 969 | |||||
| 25 | 993 | |||||
| 26 | 994 | |||||
| 27 | 986 | |||||
| 28 | 988 | |||||
| 29 | 1002 | |||||
| 30 | 983 | |||||
| 31 | 1001 | |||||
| 32 | 973 | |||||
| 33 | 1003 | |||||
| 34 | 1003 | |||||
| 35 | 984 | |||||
| 36 | 990 | |||||
| 37 | 985 | |||||
| 38 | 990 | |||||
| 39 | 991 | |||||
| 40 | 983 | |||||
| 41 | 992 | |||||
| 42 | 990 | |||||
| 43 | 996 | |||||
| 44 | 991 | |||||
| 45 | 994 |
