Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Submit ONLY this completed Google Sheets file for both problems on this lab. Note this file has two worksheets named Problem 1 and Problem 2.
Submit ONLY this completed Google Sheets file for both problems on this lab. Note this file has two worksheets named "Problem 1" and "Problem 2". Problem 1 A student team in a business statistics course conducted an experiment to test the download times of three different types of computers (MAC, iMac, and Dell) available at the university library. The students randomly selected one computer of each type. The students then went to Microsoft's game website and clicked download on the link for the NBA game. The time (in seconds) between clicking on the link and the completion of the download was recorded. After each download the file was deleted, and trash folder was emptied. A total of 30 downloads were completed in random order. The data collected is presented below. Perform the appropriate ANOVA procedure (think, should I use One-Way or Two-Way?) and be sure to show the null and alternative hypotheses that you are testing clearly. If necessary, you should identify which mean pairs are different (Tukey-Kramer Procedure). Be sure to state your results as they relate to the specific problem. Do not just give answers. Force yourself to write or type up this mini-analysis in a clear way. (Use 0.05 level of significance for all the tests). I encourage you to try Problem 1 by hand for practice as this is a problem that I can ask you to do by hand. Then confirm your results using Google Sheets. Results from experiment: MAC iMAC Dell 156 160 236 166 165 238 148 184 257 160 192 242 139 197 282 151 172 253 158 189 270 167 179 256 142 200 267 219 193 259
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started