The Excel output for the multiple regression equation is shown below: a) Which i

Question

The Excel output for the multiple regression equation is shown below: a) Which is the estimated multiple regression equation that can be used predict the overall score given the scores for Shore Excursions and Food/Dining. b) Is Shone Excursions or Food/Dining having a stronger relationship with the Overall score? c) Predict the overall score for a cruise ship with a Shore Excursions score of 80 and a Food/Dining Score of 90. d) Conduct a t test of significance for Shore Excursions if sigma = 0.05. Which is your conclusion? e) Calculate the multiple coefficient of determination. f) How much of the variability in overall score is explained by the Shore Excursion and Food/Dining. Twenty five samples of 100 items each were inspected when a process was considered to be operating satisfactory. In the 25 samples, a total of 135 items were found to be defective. a) What is an estimate of the proportion defective when the process is in control? b) What is the standard error of the proportion if samples of side 100 will be used for statistical process control? c) Compute the upper and lower control limits for the control chart. d) Which of the following sample proportions shows that the process is out of control? 0.052 0.005 0.031 0.018 0.15 0.1 For the Hawking Company, the monthly percentages shipments received on time over the past 6 months are 80, 82, 83, 84, 84, and 85. a) Construct a time series plot. What type of pattern exists in the data? b) Compare the three month moving average approach with the exponential smoothing approach for alpha = 0.2. Which provides more accurate forecasts using MSE as the measure forecast accuracy? c) What is the moving forecast for the month? Formulas Test statistic for one population mean z = x - mu/sigma/Squareroot n Test statistic for the difference between two population means (sigma and sigma unknown): = (x_1 - x_2)/Squareroot x^2_1 - x^2_2

Explanation / Answer

4 a) The estimated multiple regression equation is Score = 53.4362 + 0.169(ShoreExcursions) + 0.2443(Food/Dining)

b) As the estimated coefficient of Food/Dining is greater than estimated coefficient of Shore Excursions, Food/Dining have a stronger relationship with the overall score.

c) Overall Score = 53.4362 + 0.169*(80) + 0.2443*(90) = 88.9432

d) t = Coefficient/Standard error = 0.169047732/0.118554818 = 1.425904
p-value at t= 1.425904 and df = 1 is 0.1946797
As, p-value < 0.05, we fail to reject the null hypothesis and conclude that Shore Excursions is not a significant variable in determining the score.

e) multiple coefficient of determination = SSR/SST = 6.825418557/19.31875 = 0.3533054

f) As, multiple coefficient of determination = 0.3533054, 35.33% of variability in overall score is explained by the Shore Excursion and Food/Dining.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.