Cost accountants often estimate overhead based on the level of production. At the XYZCompany, they have collected information on overhead expenses and units produced at differentplants and want to estimate a regression equation to predict future overhead. The data is availableas given in the table below.a)b)Develop the regression equation for the cost accountants using Least Square Method.Predict overhead when 50 units are produced.Overhead Units15972138742408512367248881417145880116621536917872

Answered: Image /qna-images/answer/268a66e7-fcb1-482a-b31c-3e198ca42f08.jpg

Cost accountants often estimate overhead based on the level of production. At the XYZ Company, they have collected information on overhead expenses and units produced at different plants and want to estimate a regression equation to predict future overhead. The data is availabl as given in the table below. Develop the regression equation for the cost accountants using Least Square Method. Predict overhead when 50 units are produced. Overhead Units 159 72 138 74 240 85 123 67 248 88 141 71 458 80 116 62 153 69 178| 72

Cost accountants often estimate overhead based on the level of production. At the XYZ Company, they have collected information on overhead expenses and units produced at different plants and want to estimate a regression equation to predict future overhead. The data is availabl as given in the table below. Develop the regression equation for the cost accountants using Least Square Method. Predict overhead when 50 units are produced. Overhead Units 159 72 138 74 240 85 123 67 248 88 141 71 458 80 116 62 153 69 178| 72

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 98% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $878.The equation of the regression line is y=1.342x+55.816. Wages [state]- 712, 746, 786, 803, 841, 879, 918, 926, 954, 979 Wages [federal]- 1,024, 1,048, 1,098, 1,135, 1,195, 1,240, 1,270, 1,299, 1,340, 1,376 Construct and interpret a 98% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $878. Select the correct choice below and fill in the answer boxes to complete your choice. (Round to the nearest cent as needed.) PICK THE CORRECT ANSWER [A] We can be 98% confident that when the average weekly wages of state government employees is $878, the average weekly wages of…
David's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands of $) on landscaping with the hope of developing a predictive model to help marketing to potential new clients. Data for 14 households may be found in the file Landscape. Click on the datafile logo to reference the data. (NEED ANSWERS FOR C, D, and E) c. Use the least squares method to develop the estimated regression equation (to 5 decimals). d. For every additional $1000 in home value, estimate how much additional will be spent on landscaping (to 2 decimals). e. Use the equation estimated in part (c) to predict the landscaping expenditures for a home valued at $575,000 (to the nearest whole number).
For the provided data, develop a regression model for overall satisfaction as a function of years of service and department that has the largest R. Note that the categorical variable department has multiple levels and will require the use of multiple dummy variables. Which department, if any, has the highest impact on roduction satisfaction? Production Production E Click the icon to view the job satisfaction data. Determine the regression model for overall satisfaction as a function of years of service and department that has the largest R. Let "Administrative" be the baseline department, let X, represent Maintenance, let X, represent Management, let X, represent Production, let X, represent Quality Control, and let Xg represent Shipping / Receiving, coding each department variable with a 1 if the person is in that department and 0 otherwise. In addition, let Xe represent Years. Enter the terms of the equation so that the X-values are in ascending numerical order by base. Select the…
What needs to change in an overall problem if one wants to use linear regression?
The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years, construct and interpret a 98% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $888 the equation of the regression line is y= 1.453x-47.386. Wages(state), X | 739|760|784|822|898|921|937|954|965| Wages (federal), Y |1,036|1,054|1,105|1,136|1,192|1,253|1,266|1,327|1,400|
The accompanying data are the caloric contents and the sugar contents (in grams) of 11 high-fiber breakfast cereals. Find the equation of the regression line. Then construct a scatter plot of the data and draw the regression line. Then use the regression equation to predict the value of y for each of the given x-values, if meaningful. If the x-value is not meaningful to predict the value of y, explain why not. Calories, x Sugar, y 140 6 200 10 160 6 160 9 170 10 180 16 190 13 210 18 190 19 170 10 170 10 The equation of the regression line is ŷ = ______ x + ______ (Round the slope to three decimal places as needed. Round the y-intercept to two decimal places as needed.) (a) x = 150 cal, (b) x = 90 cal, (c) x = 175 cal, (d) x = 208 cal…
Researchers are interested in predicting the height of a child based on the heights of their mother and father. Data were collected, which included height of the child ( height), height of the mother ( mothersheight ), and height of the father (fathersheight ). The initial analysis used the heights of the parents to predict the height of the child (all units are inches). The results of the analysis, a multiple regression, are presented below. . regress height mothersheight fathersheight Source Model Residual Total height mothersheight fathersheight _cons SS 208.008457 314.295372 522.303829 df 2 104.004228 8.49446952 37 MS 39 13.3924059 Coef. Std. Err. .6579529 .1474763 .2003584 .1382237 9.804327 12.39987 t P>|t| 4.46 0.000 C 0.156 0.79 0.434 Number of obs = F( 2, 37) = Prob > F R-squared Adj R-squared = Root MSE = = .3591375 -.0797093 -15.32021 = 40 12.24 0.0001 0.3983 0.3657 2.9145 [95% Conf. Interval] .9567683 .4804261 34.92886 What are the null and alternative hypotheses…
The value of a sports franchise is directly related to the amount of revenue that a franchise can generate. Below is the data that represents the value (in $millions) and the annual revenue (in $millions) for 30 Major League Baseball franchises. Suppose you want to develop a simple linear regression model to predict franchise value based on annual revenue generated. Team Revenue Value Baltimore 179 460 Boston 310 1000 Chicago White Sox 214 600 Cleveland 178 410 Detroit 217 478 Kansas City 161 354 Los Angeles Angels 226 656 Minnesota 213 510 New York Yankees 439 1850 Oakland 160 321 Seattle 210 585 Tampa Bay 161 323 Texas 233 674 Toronto 188 413 Arizona 186 447 Atlanta 203 508 Chicago Cubs 266 879 Cincinnati 185 424 Colorado 193 464 Houston 196 549 Los Angeles 230 1400 Miami 148 450 Milwaukee 195…
2. The table below lists the annual land-line phone cost per costumer: Year 2012 2013 2014 2015 Cost ($) a. 692 610 Find a linear regression model for this data b. Interpret the slope of the model 580 C. Predict the annual land-line phone cost per customer in 2022 495 2016 434
A professor in the School of Business in a university polled a dozen colleagues about the number of professional meetings they attended in the past five years (x) and the number of papers they submitted to refereed journals (y) during the same period. The summary data are provided. Fit a simple linear regression model between x and y by finding out the estimates of intercept and slope. Comment on whether attending more professional meetings would result in publishing more papers. n n n = 12, x = 4, y = 12, X₁Y₁ = 320 i=1 x² = 234, i=1 The estimated regression line is y = 36.4 + (-6.10 )x. (Round to two decimal places as needed.) Comment on whether attending more professional meetings would result in publishing more papers. Let it be unclear that attending more professional meetings affects the number of published papers if the value used to make that determination is between 1 and 1. Because the of the regression equation is it would appear that attending more professional meetings ▼
Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fok has seen each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year. Year Number of Patients Robbery Rate per 1,000 Population The simple linear regression equation that shows the best relationship between the number of patients and the robbery rate is (round your responses to three decimal places) where y Number of Patients and x = Robbery Rate. = 1 2 3 4 6 7 36 33 40 41 55 60 58.3 61.1 73.4 75.7 81.1 89.0 101.1 5 40 8 54 94.8 9 58 103.3 10 61 116.2
The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 99% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $818. The equation of the regression line is y = 1.451x - 40.698. Wages (state), x Wages (federal), y 713 760 785 805 851 870 921 926 947 985 1,002 1,045 1,091 1,145 1,185 1,239 1,281 1,307 1,320 1,400 Construct and interpret a 99% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $818. Select the correct choice below and fill in the answer boxes to complete your choice. (Round to the nearest cent as needed.) O A. We can be 99% confident that when the average weekly wages of state government employees is $818, the average weekly wages of federal government employees will be between $ and…