QI. We use the data for Space Mars of cost driver and Indirect_Manufacturing Labor Costs. (Data) cost driver: Machine Hours(X) Indirect Manufacturing Labor Costs(Y) 1,200 week 1 68 70 1,400 67(lowest) 90(highest) 7 1,180 8 1,650 (Results) SUMMARY OUTPUT

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter7: Analytic Trigonometry
Section7.6: The Inverse Trigonometric Functions
Problem 92E
icon
Related questions
Question
Q1. We use the data for Space Mars of cost driver and Indirect Manufacturing
Labor Costs.
(Data)
week
cost driver: Machine Hours(X)
Indirect Manufacturing Labor Costs(Y)
68
70
1,200
1,400
1
67(lowest)
90(highest)
7
1,180
8
1,650
(Results)
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R
Square
Standard
Error
0.965504
0.932198
0.920897
4.097673
Observations
8
ANOVA
Significance F
1E-04
df
S
MS
F
Regression
1
1385.129
1385.129
82.49274
Residual
6
100.7456
16.79093
Total
7
1485.875
Standard
Error
Coefficients
t Stat
P-value
Intercept
X Variable
-62.0077
14.4556
-4.28953
0.005152
0.105775
0.011646
9.082551
1E-04
(a) What is the estimated indirect labor cost based on the regression line when
X=75?
(b) Evaluate the goodness of fitness of this regression line.
(c) Describe the meaning of R
(d) Explain the meaning of F
(e) Estimate Indirect Manufacturing Labor Costs(Y) function by using "High Low
Method"
2.
Transcribed Image Text:Q1. We use the data for Space Mars of cost driver and Indirect Manufacturing Labor Costs. (Data) week cost driver: Machine Hours(X) Indirect Manufacturing Labor Costs(Y) 68 70 1,200 1,400 1 67(lowest) 90(highest) 7 1,180 8 1,650 (Results) SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error 0.965504 0.932198 0.920897 4.097673 Observations 8 ANOVA Significance F 1E-04 df S MS F Regression 1 1385.129 1385.129 82.49274 Residual 6 100.7456 16.79093 Total 7 1485.875 Standard Error Coefficients t Stat P-value Intercept X Variable -62.0077 14.4556 -4.28953 0.005152 0.105775 0.011646 9.082551 1E-04 (a) What is the estimated indirect labor cost based on the regression line when X=75? (b) Evaluate the goodness of fitness of this regression line. (c) Describe the meaning of R (d) Explain the meaning of F (e) Estimate Indirect Manufacturing Labor Costs(Y) function by using "High Low Method" 2.
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Anova and Design of Experiments
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage