Suppose the Sherwin-Williams Company is interested in developing a simple regression model with paint sales (Y) as the dependent variable andselling price (P) as the independent variable.Complete the following worksheet and then use it to determine the estimated regression line.Sales Regioni12345678910TotalSelling Price($/Gallon)Xi1513.516.514.5171613181215.5151Sales(x 1000 Gal)Yi1602201401901201602101502001901,740Regression Parameters EstimationsSlope (B)Intercept (a)xiyi2,4002,9702,3102,7552,0402,5602,7302,7002,4002,945x;²225182.25272.25210.25289256169324144240.252,312In words, for a dollar increase in the selling price, the expected sales willyi²25,60048,40019,60036,10014,40025,60044,10022,50040,00036,100bygallons in a given sales region.

Here the dependent variable (y) is paint sales.The independent variable (x) is the selling…

Answered: Complete the following worksheet and…

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 following data are the monthly salaries y and the grade point averages x for students who obtained a bachelor's degree in business administration. GPA 2.6 3.4 3.6 3.2 3.5 2.9 Monthly Salary ($) 3,500 3,900 4,200 3,800 4,200 3,900 The estimated regression equation for these data is ý = 1,970.72 + 608.11x and MSE = 18,671.17. (a) Develop a point estimate of the starting salary (in dollars) for a student with a GPA of 3.1. (Round your answer to the nearest cent). (b) Develop a 95% confidence interval for the mean starting salary (in dollars) for all students with a 3.1 GPA. (Round your answers to the nearest cent). to $ (c) Develop a 95% prediction interval (in dollars) for Ryan Dailey, a student with a GPA of 3.1. (Round your answers to the nearest cent). to $
Fit a linear regression model for the following data.
The following data are the monthly salaries and the grade point averages for students who obtained a bachelor's degree in mathematics. GPA: 2.6, 3.4, 3.6, 3.2, 3.5, and 2.9; Monthly Salary: 330o, 3600, 4000, 3500, 3900, and 3600. Plot the scatter diagram showing the deviations about the estimated regression line and the line y = y(bar).
2. Following data is amount of Assessed Value for an office building for a given floor area, number of office space, number of entrances, and the age of the offic building. Use excel to …. Obtain a Scatter plot of Floor Area as the independent and Assessed value as the dependent variable. Note the linear regression Model Predict the assessed value for 6000 sq ft. FloorArea (Sq.Ft.) Offices Entrances Age AssessedValue ($'000) 4790 4 2 8 1796 4720 3 2 12 1544 5940 4 2 2 2094 5720 4 2 34 1968 3660 3 2 38 1567 5000 4 2 31 1878 2990 2 1 19 949 2610 2 1 48 910 5650 4 2 42 1774 3570 2 1 4 1187 2930 3 2 15 1113 1280 2 1 31 671 4880 3 2 42 1678 1620 1 2 35 710 1820 2 1 17 678 4530 2 2 5 1585 2570 2 1 13 842 4690 2 2 45 1539 1280 1 1 45 433…
Which of the following is not one of the uses of a scatter plot and regression line a. to estimate the average y at a specific value of x. b. All three are uses of the scatterplot and regression line c. to determine if a change in x causes a change in y d. to predict y at a specific value of x.
You are given the following data, where X1 (final percentage in math class) and X2 (number of absences) are used to predict Y (standardized math test score in third grade): Y X1 X2 345 70 390 80 1 370 75 4 375 92 400 82 350 70 3 310 61 5 420 80 375 88 3 410 72 1 485 99 300 65 7 Determine the following multiple regression values. Report intercept and slopes for regression equation accurate to 3 decimal places: Intercept: a = Partial slope X1: bị = Partial slope X2: bz = Report sum of squares accurate to 3 decimal places: SSreg Test the significance of the overall regression model (report F-ratio accurate to 3 decimal places and P-value accurate to 4 decimal places): F-ratio = P-value = Report the variance of the residuals accurate to 3 decimal places: Sres = Report the results for the hypothesis test for the significance of the partial slope for final percentage in math class (report the test statistic for the regression coefficients accurate to 3 decimal places and P-value accurate to…
Given the following, determine the price of a Corolla that is six years old given the graph of the regression line.
Perform a linear regression analysis on the following data and determine the "a" coefficient (i.e., slope): Y 4.99 22.19 1.96 9.89 2.98 11 9 40.46 4.04 18.93 6.06 25 0.88 0.19 8.02 34.02 6.97 28.03
Please don't use Exel for solving, I need manual steps
The following table contains ACT scores and the GPA for eight college students. Estimate the relationship between GPA (yi) and ACT (x;) using OLS regression by hand. Report the intercept and slope estimates: Student 1 2 3 4 5 6 7 8 GPA 2.8 3.4 3.0 3.5 3.6 3.0 2.7 3.7 ŷ₁ =B₁ + B₁x₁ ACT 21 24 26 27 29 25 25 30 y X ŷ₁
3. Find the equation of the regression line for the data and graph the scatter plot for the data No of ads (x) Sales (y) 2 5 8 8 10 12 2 4 7 9 10 Find yl at x = 47 ads

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS