The manager of computer operation of a large company wants to study computer usage of two...

70.2K

Verified Solution

Question

Basic Math

The manager of computer operation of a large company wants tostudy computer usage of two departments within the company-theaccounting dept. and the research dept. A random sample of fivejobs from the accounting dept. in the past week and six jobs fromthe research dept. in the past week are selected, and theprocessing time(in seconds) for each job is recorded. Use a levelof significance of 0.05, 1. Please provide descriptive stat. forthe data ( Excel) 2. Is there evidence that the mean processingtime in the research dept. is greater 6 seconds? ( Hand calculated,but use mean and SD from Excel output) 3. Is there evidence of adifference between the mean processing times of these twodepts.?(Please use Excel, then you will use hand calculation todouble check your answer) For question 2 and 3, make sure that youwrite down H0 and H1, conclusion and summary.
Accounting 9 3 8 7 12
Research 4 13 10 9 9 6

Answer & Explanation Solved by verified expert

4.0 Ratings (570 Votes)

1 We have to find the descriptive statistic using excelX1 AccountingX2 Researchn1 5n2 6 Mean of accounting 78 Use command AVERAGEselect x1values Mean of research 85 Use command AVERAGEselect x2valuess1 Standard deviation of accounting 3271085 Use commandSTDEVSelect x1 valuess2 Standard deviation of accounting 3146427 Use commandSTDEVSelect x2 See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member