Up till now, we provide 9999 solutions for all subjects which include Mathematics, Finance, Accounting, Management, Engineering, Computer Science, Natural Sciences, Medicine Science, etc.

i. Use MS Excel Data Analysis ToolPak to perform a multiple regression analysis using Quality as the response variable and Helpfulness and Clarity as the explanatory variables. Write down the corresponding coefficient estimates and provide the regression output. j. Perform an F-test for the overall usefulness of the model in part i) using a 5% significance level. Make sure you follow all the steps for hypothesis testing indicated in the Instructions section and clearly state your conclusion. k. Test manually if the Clarity variable is significant in the model in part i). Make sure you follow all the steps for hypothesis testing indicated in the Instructions section and clearly state your conclusion. l. Using the adjusted R2 criterion, does including Clarity as an additional predictor variable improve the model in part i)? Explain why it is better to use the adjusted R2 over the R2 to determine if the addition of this new variable improves the model. Regression Statistics ANOVA Multiple R 0.998544859 df SS MS F Significance F R Square 0.997091836 Regression 2 255.2639136 127.6319568 62229.00058 0 Adjusted R Square 0.997075813 Residual 363 0.744514614 0.002051004 Standard Error 0.045288017 Total 365 256.0084282 Observations 366 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -0.020353502 0.010520921 -1.934574223 0.0538193 -0.04104311 0.000336106 -0.04104311 0.000336106 helpfulness 0.538358378 0.007216008 74.60611907 2.8925E-222 0.524167949 0.552548808 0.524167949 0.552548808 clarity 0.465505241 0.00707634 65.78333849 8.6445E-204 0.451589474 0.479421009 0.451589474 0.479421009

1 Solutions

See Answer
  QUESTION 1 On a particular day, Mobay Electronics produced 10000 electric bulbs at a mean production rate of 10 hours. Assume that the known population standard deviation is 2000 hours   a. Why do we need a confidence interval                                                                         We need to construct a confidence interval because people may take samples from a population and end up with different result. Therefore, we do not know the true value until we create a confident interval   b. Construct a 95% confidence interval for the mean production time of the light bulbs by Mobay electronics      QUESTION 2 Given the following numbers 2, 2, 3, 2, 4, 8, 0 Find a. The mean                                                                            b. the mode                                                                          c. the median                                                       d. the variance                                                    QUESTION 3 The average weight of 20 students in a certain school was found to be 165lbs with a standard deviation of 4.5. Construct a 95% confidence interval for the population mean. Please show all working  to show how you arrived at the answer QUESTION 4 At a large restaurant, 3 out of 5 customers ask for water with their meal. A random sample of 10 customers is selected. Find the probability that a. Exactly 6 ask for water with their meal                      b. Less than 9 ask for water with their meal              QUESTION 5 Patients arrive at a hospital Accident and Emergency department at random at a rate of 6 per hour. Find the probability that during any 90 minute period, the number of patients arriving at the hospital Accident and Emergency department is Exactly 7                                                                                            At least 1                                                                                                                                                                                                                                                                                                                                                                    

1 Solutions

See Answer
A soft drink bottler is interested in obtaining more uniform fill heights in the bottles produced by his manufacturing process. The filling machine theoretically fills each bottle to the correct target height, but in practice, there is variation around this target, and the bottler would like to understand the sources of this variability better and eventually reduce it. The process engineer can control three variables during the fill process: the percent carbonation (A), the operating pressure in the filler (B), and the bottles produced per minute or the line speed (C). The pressure and speed are easy to control, but the percent carbonation is more difficult to control during the actual manufacturing process because it varies with product temperature. For the purposes of this experiment, the engineer can control carbonation at two levels: 10 and 14 percent. She chooses two levels for pressure (25 and 30 psi) and two levels for line speed (200 and 250 bpm). She decides to run two replicates of a factorial design in these three factors, with all runs taken in random order.   1.What does it mean for the engineer to run two replicates of the factorial design? 2.How would the experiment be different if she planned to use repeats (instead of replicates)? 3.What is the difference between repetition and replication? How does this difference affect the type of variability we can explore in an experiment? 4.How might the engineer incorporate blocking into this experiment? What would be the advantages and disadvantages of doing so?  

1 Solutions

See Answer