View the step-by-step solution to:

NUMBER COST 30 94 35 109 32 99.5 33 100 30 91.5 29 85.5 24 80.5 20 74.5 22 79 27 85 26 81.5 29 88 31 96 34 103 33 103 32 97 30 90 28 86.5 22 77.5 23...

This question was answered on Jan 30, 2013. View the Answer
The file COSTEST 3 on the CD contains data on production runs at a manufacturing plant. There are two columns of data:
y= COST is the total cost of the production run
x= NUMBER is the number of items produced during that run
Run the regression using COST as the dependent variable and NUMBER as the independent variable and use the result to help answer the following questions:
A: what is the estimated regression equation relating y to x?
B: What percentage of the variation in y has been explained by the regression?
C: Are Y and x linearly related? Conduct a hypothesis test to answer this question and use a 5% level of significance. State the hypotheses to be tested, the decision rule, the test statistic, and your decision. What conclusion can be drawn from the result of the test?
D. Estimate the fixed cost involved in the production process. Find a point estimate and a 95% confidence interval estimate.
E. Estimate the variable cost involved in the production process. Find point estimate and a 95 % confidence interval estimate.

Place this in a single workbook on separate sheet (Excel). Answer the question below the output and clearly label the answers. I don't want mere numbers for answers. Justify your answers by referring to the output and explain them in the context of the problem. You don't have to calculate any number which is found on the output, just use it. Write a quantitative report.
NUMBER COST 30 94 35 109 32 99.5 33 100 30 91.5 29 85.5 24 80.5 20 74.5 22 79 27 85 26 81.5 29 88 31 96 34 103 33 103 32 97 30 90 28 86.5 22 77.5 23 81 25 83.5 27 82.5 25 81 28 85
Background image of page 1
Sign up to view the entire interaction

Top Answer

Here is the solution... View the full answer

8425795.xlsx

NUMBER COST
30
94
35
109
32
99.5
33
100
30
91.5
29
85.5
24
80.5
20
74.5
22
79
27
85
26
81.5
29
88
31
96
34
103
33
103
32
97
30
90
28
86.5
22
77.5
23
81
25
83.5
27
82.5
25
81
28
85 SUMMARY OUTPUT...

This question was asked on Jan 29, 2013 and answered on Jan 30, 2013.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards