Question

In: Statistics and Probability

Consider the following sample of production volumes and total cost data for a manufacturing operation.

You may need to use the appropriate technology to answer this question.

Consider the following sample of production volumes and total cost data for a manufacturing operation.

Production Volume
(units)
Total Cost
($)
400 4,100
450 5,000
550 5,500
600 5,900
700 6,500
750 7,000

This data was used to develop an estimated regression equation,

ŷ = 1,342.67 + 7.52x,

relating production volume and cost for a particular manufacturing operation. Use

α = 0.05

to test whether the production volume is significantly related to the total cost. (Use the F test.)

State the null and alternative hypotheses.

H0: β1 ≠ 0
Ha: β1 = 0H0: β1 ≥ 0
Ha: β1 < 0    H0: β0 ≠ 0
Ha: β0 = 0H0: β0 = 0
Ha: β0 ≠ 0H0: β1 = 0
Ha: β1 ≠ 0

Set up the ANOVA table. (Round your p-value to three decimal places and all other values to two decimal places.)

Source
of Variation
Sum
of Squares
Degrees
of Freedom
Mean
Square
F p-value
Regression
Error
Total

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

What is your conclusion?

Do not reject H0. We cannot conclude that the relationship between production volume and total cost is significant.

Reject H0. We cannot conclude that the relationship between production volume and total cost is significant.     

Reject H0. We conclude that the relationship between production volume and total cost is significant.

Do not reject H0. We conclude that the relationship between production volume and total cost is significant.

Solutions

Expert Solution

Solution) :

Here,

Production Volume is independent variable(X)

Total cost is dependent variable(Y) .

Enter data in SPSS software as given below:

In variable view:

Production Volume   as (scale) measure.

Total cost   as (scale) measure.

In variable view:

Enter the data for both columns

To get the entered data in output :

Steps= analyse --- reports ---case summaries ---select both variable in variables column---ok

Production_Volume

Total_Cost

1

400

4100

2

450

5000

3

550

5500

4

600

5900

5

700

6500

6

750

7000

To perform simple regression in SPSS :

Steps : Analyse ---Regression---Linear---Dependent(Total cost)---Independent(Production volume)---method(enter)---Ok

Model Summary

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

1

.986a

.972

.965

194.765

a. Predictors: (Constant), Production_Volume

R-square =0.972

Which means there is approximately 97.2% variability in Dependent variable(Total Cost) is explained by Independent Variable(Production Volume).

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

B

Std. Error

Beta

1

(Constant)

1342.667

374.300

3.587

.023

Production_Volume

7.520

.636

.986

11.822

.000

a. Dependent Variable: Total_Cost

Here, from the above coefficient table ,we have

Intercept (β0) = 1342.67

Slope (β1)       = 7.52

The Regression Equation is :

Ŷ = β01X

    =1342.67+7.52*X

Now,State the null and alternative hypotheses.

H0: β1 = 0   there is not significant relationship between production volume and total cost.
Ha: β1 ≠ 0    there is significant relationship between production volume and total cost.

ANOVAa

Model

Sum of Squares

df

Mean Square

F

Sig.

1

Regression

5301600.00

1

5301600.00

139.76

.000b

Residual

151733.33

4

37933.33

Total

5453333.33

5

a. Dependent Variable: Total_Cost

b. Predictors: (Constant), Production_Volume

Test statistic Value ,F=139.76

p-value =0.000<0.05 ,which means that regression is significant at 5% level of significance.

Conclusion: since p value is less than 0.05

.     Reject H0. We conclude that the relationship between production volume and total cost is significant.


Related Solutions

Consider the following sample of production volumes and total cost data for a manufacturing operation. Production...
Consider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume (units) Total Cost ($) 400 4,000 450 4,900 550 5,400 600 6,000 700 6,300 750 6,900 This data was used to develop an estimated regression equation, ŷ = 1,305.33 + 7.44x, relating production volume and cost for a particular manufacturing operation. Use α = 0.05 to test whether the production volume is significantly related to the total cost. (Use the F test.) State...
Consider the following sample of production volumes and total cost data for a manufacturing operation. Production...
Consider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume (units) Total Cost ($) 400 4,000 450 5,000 550 5,300 600 5,900 700 6,400 750 6,900 This data was used to develop an estimated regression equation, ŷ = 1,305.33 + 7.44x, relating production volume and cost for a particular manufacturing operation. Use α = 0.05 to test whether the production volume is significantly related to the total cost. (Use the F test.) (a)...
Frazier Manufacturing Company collected the following production data for the past month: Units Produced Total Cost...
Frazier Manufacturing Company collected the following production data for the past month: Units Produced Total Cost 1,600 $66,000 1,300 57,000 1,500 67,500 1,100 49,500 If the high-low method is used, what is the monthly total cost equation? A. Total cost = $0 + $45/unit B. Total cost = $13,200 + $33/unit C. Total cost = $16,500 + $30/unit D. Total cost = $9,900 + $36/unit I know the answer is $13,200+33/unit. But I do not see how the math is...
explain production process, manufacturing operation and service operation.
explain production process, manufacturing operation and service operation.
The Painting Department of Y Manufacturing Company has the following production and manufacturing cost data for...
The Painting Department of Y Manufacturing Company has the following production and manufacturing cost data for October. Production: Beginning inventory 8,000 units that are 100% complete as to materials and 40% complete as to conversion costs; units started into production 27,000; ending inventory of 12,000 units that are 20% complete as to conversion costs. Manufacturing Costs: Beginning work in process inventory of $40,000, comprised of $30,000 of materials and $10,000 of conversion costs. Materials added during the month, $110,000; labor...
Consider the following data on the quantity of production and its cost (in dollars) for a...
Consider the following data on the quantity of production and its cost (in dollars) for a particular customized component, for each of 10 weeks.                                              NumberProduced                              Cost                                                      16                                             207.17                                                        6                                               90.93                                                      18                                             227.22                                                      10                                             153.61                                                      13                                             155.97                                                        3                                               68.24                                                        9                                             112.00                                                      16                                             185.77                                                      20                                             260.48                                                        5                                               80.62 a.   Find the usual statistical measure for the strength of the association between cost and number produced. Please give both the name and...
The Polishing Department of Sunland Company has the following production and manufacturing cost data for September....
The Polishing Department of Sunland Company has the following production and manufacturing cost data for September. Materials are entered at the beginning of the process. Production: Beginning inventory 1,800 units that are 100% complete as to materials and 30% complete as to conversion costs; units started during the period are 43,600; ending inventory of 5,600 units 10% complete as to conversion costs. Manufacturing costs: Beginning inventory costs, comprised of $21,500 of materials and $33,186 of conversion costs; materials costs added...
The Polishing Department of Major Company has the following production and manufacturing cost data for September....
The Polishing Department of Major Company has the following production and manufacturing cost data for September. Materials are entered at the beginning of the process. Production: Beginning inventory 1,620 units that are 100% complete as to materials and 30% complete as to conversion costs; units started during the period are 44,700; ending inventory of 6,800 units 10% complete as to conversion costs. Manufacturing costs: Beginning inventory costs, comprised of $21,300 of materials and $19,580 of conversion costs; materials costs added...
The Sanding Department of Coronado Furniture Company has the following production and manufacturing cost data for...
The Sanding Department of Coronado Furniture Company has the following production and manufacturing cost data for March 2020, the first month of operation. Production: 6,260 units finished and transferred out; 3,000 units started that are 100% complete as to materials and 20% complete as to conversion costs. Manufacturing costs: Materials $35,188; labor $21,500; overhead $35,438. Prepare a production cost report. (Round unit costs to 2 decimal places, e.g. 2.25 and other answers to 0 decimal places, e.g. 125.) CORONADO FURNITURE...
The Polishing Department of Coronado Company has the following production and manufacturing cost data for September....
The Polishing Department of Coronado Company has the following production and manufacturing cost data for September. Materials are entered at the beginning of the process. Production: Beginning inventory 1,520 units that are 100% complete as to materials and 30% complete as to conversion costs; units started during the period are 46,300; ending inventory of 6,800 units 10% complete as to conversion costs. Manufacturing costs: Beginning inventory costs, comprised of $20,500 of materials and $34,645 of conversion costs; materials costs added...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT