CoursHeroTranscribedText: 2012-2014 2012-2014 Monthly Monthly Computer AC (y-bar) PP (x-bar) 1 $347.52 36.3 2 $347.11 37.1 3 $353.43 40.4 4 $342.10 34.3 5 $336.01 35.1 6 $340.10 37.6 7 $336.20 38.1 8 $328.99 32.3 9 $331.21 39.5 10 $340.12 36.6 11 $326.78 32.8 12 $324.52 33.0 13 $279.57 35.6 14 $336.78 37.4 15 $334.03 35.9 16 $327.57 32.8 17 $326.98 31.7 18 $335.43 35.3 19 $329.75 34.4 20 $328.97 35.5 21 $338.99 37.7 22 $274.89 37.4 23 $345.22 36.1 24 $332.91 34.4 25 $289.76 32.4 26 $335.62 37.6 27 $333.27 36.2 28 $298.74 40.2 29 $324.31 27.4 30 $359.96 38.3 31 $355.78 39.1 32 $347.85 36.2 33 $274.89 37.4 34 $345.22 36.1 35 $332.91 34.4 36 $289.76 32.4 2016 Daily Computer AC (y) 1 $345.35 2 $346.25 3 $351.65 4 $341.75 5 $347.00 6 $288.95 7 $342.50 8 $330.35 9 $326.85 10 $341.25 11 $329.55 12 $327.85 13 $329.00 14 $363.50 15 $341.25 16 $329.90 17 $324.50 18 $338.90 19 $331.60 20 $333.80 21 $343.45 22 $352.35 23 $351.95 24 $289.90 25 $331.75 26 $336.75 27 $341.65 28 $356.75 29 $330.95 30 $360.25 31 $297.25 32 $348.95 33 $324.50 34 $338.90 35 $331.60 36 $333.80 2016 Daily PP (x) 36 38 39 35 35 36 38 34 36 36 34 33 36 38 37 33 30 34 34 36 38 37 36 33 32 38 36 39 31 36 40 38 30 34 34 36 Probability and Statistics for Engineers Due 08-08-16 Math 2100 Form Computers Final Project This project should be done in groups of 2 to 3 people. Rubric - In order to earn full credit for this project, you must submit all of the data indicated below. Spread out your work to include multiple pages. Be sure that each individual chart, graph or diagram is not split between pages. Use R for all diagrams, tables, graphs, and computations. Report must have a front and rear cover and passed in to me on or before 08-08-16 for full credit. Be sure to include your names, IDs, and all pertinent tables, diagrams, graphs and computations. On the rear cover, describe in your own words what computational methods you learned in Math2100 that were used to complete this project. Data The spreadsheet entitled Computers Stats consists of the mean monthly assembly cost (AC) and the mean monthly percent of profit (PP) earned by the company for the 36 months from 2012-2014 as well as the assembly cost and the monthly percent of profit for the first 36 days of production during January and February of 2016 following a change in Ownership. 1. For AC and PP in the 2016 stats, perform the following computations: a. Find the mean, median and mode. b. Find the standard deviation s of this sample week. c. Create a frequency distribution table with 4 classes. d. Create a histogram using your frequency table. e. Draw a boxplot of the assembly costs. f. Using the results from parts a) and b) to find what percentage of the 36 days' AC is within 1 of the mean. (Hint: Assume this sample was NOT taken from a Bell curve.) g. If 35.4% or more is considered a good percentage of profit, what percentage of the 36 days' PP are 35.4% or more? h. If we assume 35.4% or more, what percentage of those profits were accomplished in with an assembly cost of $330 or less? 2. Assuming that the 36 months' mean AC for the first 36 months is a normal distribution, perform the following: a. Find the mean and the standard deviation , then find what percent of AC was between $320 and $350 per month. b. Use the 36 months of statistics to create a scatterplot with AC on the x-axis and PP on the y-axis. c. Draw in a trend line and calculate the equation for the line of regression. d. Using this equation from part c), approximate to the nearest whole number the percent of profit that could result from requiring an average assembly cost of $340 during the 36 months and approximate to the nearest cent the assembly cost that would result in producing an average of 34.7% per month during that same 36 months. e. Using R, show that the data you used to establish your sample of sample means for the first semester is normally distributed by creating a Normal Quantile Plot. 3. Assuming that the 36 days in January and February are a representative sample and that the 36 days' AC fit a Normal Distribution Curve, do an estimation of the Mean by establishing a margin of error and a confidence interval of the mean assembly cost recorded during the 36 days. Use 95% confidence-level. 4. For the 36 months from 2012-2014, you calculated the mean AC by the company in a month as well as the standard deviation. Use these as the basis for the mean hypothesis claim, H0. a) Has this changed during the 36 days in January and February of 2016? b) State your Alternative Hypothesis. c) Use a significance level of = 0.05 to find a Z-test and a P-value that either supports or rejects the null hypothesis. d) Using the sample of the 36 days in January and February for the company' AC, has there been a significant statistical change in the mean AC since 2014? State your conclusion in one descriptive sentence