Problem 1:The following data was taken from experiment. The data can be modeled by the followingequation.ya = b10va(x²+0.5)0.100.300.450.550.70y0.520.600.680.751.00a) Find the values of a and b using least square regression.b) Then use the resulting model to predict y at x 0.035

Answered: Problem 1: The following data was taken…

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

Multiple regression analysis examines the linear relationship between a dependent variable (y) and two or more independent variables (x1, x2, and so on). True False
25. Consider the following time series data: Quarter 1 234 Year 1 4 4235 2 5 Year 2 6357 5 7 Year 3 7 6 6 8 a. Construct a time series plot. What type of pattern exists in the data? b. Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.
The following correlation coefficient values come from five different linear regression models. Which model "fits" the data the best? D -8 0.50 00 0.99 O -1
Explain what is meant by standard deviation and how to find it. Find an example of a situation with a small data set and determine the standard deviation. Explain what the standard deviation means in context of the situation.
In a sample of 103 bags of dog food, the average weight was found to be 21.5⁢lb with a standard deviation of 0.5. Give a point estimate for the population variance of the weight of the bags of dog food. Round your answer to two decimal places, if necessary.
Walmart collects data that depicts the number of customers who return merchandise for a refund. The following data shows the population returns for all 10 Tuesdays. 40 12 17 46 13 22 259 167 Assume that this same exact pattern of data were replicated for the next ten days. How would this affect the standard deviation for the new population with 20 items? (Hint: Find the standard deviation first). The standard deviation would not be changed. There is no way of knowing the exact impact without knowing how the mean is changed. The standard deviation would be doubled. The standard deviation would be cut in half.
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 a. Construct a time series plot. What type of pattern exists in the data? Trend Pattern Seasonal Pattern Horizontal Pattern O Trend and Seasonal Pattern Question 11 5 pts b. Create the following dummy variables: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Create a variable t such that t = 1 for quarter 1 of year 1, t = 2 for quarter 2 of year 1, ..., t = 12 for quarter 4 of year 3. Use these dummy variables and t to develop an estimated regression equation to account for seasonal effects and any linear trend in the data. What is the forecast for quarter 1 of next year?
8. assignment variable at which the treatment status does NOT change In Regression Discontinuity framework, the cutoff is defined as the level of the True False 9. What regression equation do we use for regression discontinuity framework? a) Y = Bo + B1 T + B2Xu+ Ei b) Y = Bo + B,T+ B2C + ei c) Y, = Bo + B, T+ B2 (Xi-C) + ei d) Y, = Bo + B1T + B2 (Xu + C) + € 10. Regression Discontinuity Design accomplices apples-to-apples comparison by comparing individuals as far from the cutoff as possible. True False
The table below summarizes the result of data analysis of research conducted in a sales organization that operates in 50 cities of the country, and ermploys a total of about 500 sales force. The sample size of this study was 150. Results of regression analysis R square 0.43459 Adjusted R square 0.35225 Standard error 0.41173 F-stat 5.278 Sig 0.000 Variable Beta Sig. I Training of 0.28 2.768 0.0092 salespersons No. of salesperson 0.34 3.55 0.00001 Population 0.09 0.97 0.467 Per capita income 0.12 1.200 0.089 Advertisement 0.47 4.54 0.00001 a) Summarize the results to the top management of the company. Assess whether the identified independent variables affect the sales performance.
Cross-Sectional Regression Analysis WasteTec is a large construction company that specializesin the construction of large wastewater treatment plants and recycling plants. A major cost driver ineither type of facility is the capacity of the plant. For example, the capacity of a recycling plant ismeasured by the number of tons of water per day (TPD) that the plant can process. These plants canvary in size from a few hundred TPD to as many as several thousand TPD. Regression analysis is auseful method to estimate the cost of a new plant by using a regression equation developed from priorplant construction projects. The dependent variable of the regression is the actual construction costsof each project, while the independent variable is the TPD for the plant. Below is a sample of somerecent projects and the related construction costs (in thousands):TPD CostsCommerce, CA 360 $ 59,369Hudson Falls, NY 400 77,013Layton, UT 420 50,405Oxford Township, NJ 450 75,779Savannah, GA 500…
4. The number of auto accidents in Athens, Ohio, is related to the regional number of registered automobiles in thou- sands (X1), alcoholic beverage sales in $10,000s (X2), and rainfall in inches (X3). Furthermore, the regression formula has been calculated as: Y=a+b1X1 +b2X2 +b3X3 Where Y = number of automobile accidents a = 7.5 bl = 3.5 b2 = 4.5 b3 = 2.5 Calculate the expected number of automobile accidents under conditions a, b, and c: X, X2 X, (a) 2 3 (b) 5 1 (c) 7 2 N m4
Records pertaining to the monthly number of job-related injuries at an underground coal mine were being studied by a government agency. The values for the past 100 months were as follows: Injuries Frequency of per Month Occurrence 32 40 2 15 3 4 1. 1. Apply the chi-square test to these data to test the hypothesis that the underlying distribution is Poisson. Important note: In the answer box below, just put the numerical test statistic value. Use x.xx format for the numerical value you provide as the answer. Do NOT compare the test statistic with the critical value from a table. Answer:

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