a. Using POM for Windows' least squares-linear regression module, develop a relationship to forecast production ratings from test scores. (Round your responses to three decisand include a minus sign if necessary.)Y= - 23 + .945 xwhere Y = Production rating and X = Test score.b. If a worker's test score was 54, what would be your forecast of the worker's production rating? 51. (Enter your response as an integer.)c. Comment on the strength of the relationship between the test scores and production ratings.The coefficient of correlation for the least-squares regression model isand the coefficient of determination is(Enter your responses rounded to three decimal places.)More infoTestScoreProductionRatingProductionTestWorkerWorkerRatingScoreA5543K5857B3843757593876748D86773126E88826249F66682425G5547Q7884Clear allCheck5046343241415158J6974T3930PrintDoneLLMN OPoRS

Coefficient of correlation = R Coefficient of Determination = R^2

Answered: c. Comment on the strength of the…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

From the following time series data of sale project the sales for the next three years. Year 2001 2002 2003 2004 2005 2006 2007 Sales (*000 units) 80 90 92 83 94 99 92
d. Now based on regression analysis predict the number of patients that Dr. Fok will see in year 11 and 12 based on the forecasted Robbery Rate - year 11 is 117.1 and year 12 is 120.8. e. What is the MAD? f. What is the correlation Coefficient – r-value? % g. Based on the overall analysis, how well does each model fit the data?
38
Please help with correct answers: step by step: last time submitted- answers were incorrect A statistical program is recommended. The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Quarter Year 1 Year 2 Year 3 1 1,690 1,800 1,850 2 940 900 1,100 3 2,625 2,900 2,930 4 2,500 2,360 2,615 a) Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to the nearest integer.) Qrt1 = 1 if quarter 1, 0 otherwise; Qrt2 = 1 if quarter 2, 0 otherwise; Qrt3 = 1 if quarter 3, 0 otherwise t = b) Using the equation developed in part (b), compute the quarterly forecasts for year 4. (Round your answers to the nearest ten.) quarter 1 forecast____? quarter 2 forecast____? quarter 3 forecast ____? quarter 4 forecast ____? c) Let t = 1 refer to the observation in Quarter 1 of Year 1; let t = 2 refer to the observation in Quarter 2 of Year…
data table below shows the number of computers sold at the Best Buy Store in a week, based on online ads. Online Ad Computers Sold 2 25 1 10 4 30 1 10 2 25 sigma)x=10 sigma)y=100 draw the graph of the regression equation, showing the slope and y intercepts?
Descriptive statistics for the closing stock prices of two companies for several trading periods are shown below. Baba, Inc Maman, Inc. Mean 4.00 Mean 15.91 Standard Error 0.11 Standard Error 0.29 Median 3.92 Median 16.59 Mode 4.19 Mode 15.58 Standard Deviation 1.12 Standard Deviation 3.21 Sample Variance 1.25 Sample Variance 10.31 Kurtosis -1.15 Kurtosis 3.52 Skewness 0.08 Skewness -2.09 Range 3.95 Range 13.45 Minimum 2.03 Minimum 5.55 Maximum 5.98 Maximum 18.99 Sum 436.32 Sum 1972.61 Count 109 Count 124 Which company's stock price has a more dispersed distribution? Maman, Inc. Baba, Inc.
8
bex Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 3.136512 0.964065 0.985521 0.971252 0971252 Given the above regression statistics, what is the value of the coefficient of determination? 0.964065 3.136512
Only question 1
Your company is preparing an estimate of its production costs for the coming period. The controller estimates that direct materials costs are $45 per unit and that direct labor costs are $23 per hour. Estimating overhead, which is applied on the basis of direct labor costs, is difficult. The controller's office estimated overhead costs at $4,000 for fixed costs and $17 per unit for variable costs. Your colleague, Lance, who graduated from a rival school, has already done the analysis and reports the "correct" cost equation as follows. Overhead = $10,511 + $15.94 per unit Lance also reports that the correlation coefficient for the regression is 0.81 and says, "With 81% of the variation in overhead explained by the equation, it certainly should be adopted as the best basis for estimating costs." When asked for the data used to generate the regression, Lance produces the following: Month LEMASTOSOHN3 1 2 4 5 6 7 8 9 10 11 12 13 Overhead Unit Production $57,064 60,683 77,008 56,624 81,700…
Based on the following regression ANOVA table, how many predictors are studied? Source df SS MS F Regression 4 1793.2356 448.3089 7.4854 Residual 45 2695.0996 59.8911 Total 49 4488.3352 1 3 4 5
In multiple regression analysis, testing the significance of individual regression coefficients is based on A t statistic A z statistic An F statistic

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS