Question

. Estimate the regression equation by using the following data. Also forecast the Sales for 2100...

. Estimate the regression equation by using the following data. Also forecast the Sales for 2100 employees.

Employees

(No.)

Sales

(millions)

1995

145

2125

136

2136

131

2165

165

2239

139

2143

157

2235

164

2500

?

(a) Develop a scatter diagram.

(b) Determine the correlation coefficient.

(c) Determine the coefficient of determination R2.

(d) Estimate the regression coefficients α and β of the equation Y= α + β X + e?

(e) Forecast the annual gross sales for 2100 employees.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
4. Data on the unemployment rate and alcohol sales were analyzed. The following regression equation was...
4. Data on the unemployment rate and alcohol sales were analyzed. The following regression equation was computed from a sample of 18 data points. ?̂ = 3 . 5 9 + . 7 2 ? (A) Complete this ANOVA table. (9) Source SS df MS F Regression Error 301.1 Total 403.8 (B) Determine the standard error of estimate. (Round to 3 decimals.) (9) (C) Determine the coefficient of determination. (Round to 3 decimals.) (9) (D) Determine the correction coefficient. Clearly...
Open Three Hospitals data. SETUP: It is believed that the number of injuries recorded in hospital...
Open Three Hospitals data. SETUP: It is believed that the number of injuries recorded in hospital 1 is different from the number of injuries recorded in hospital 2. Given the data your job is to confirm or disprove this assertion. 10. What test/procedure did you perform? (4 points) a. Regression b. Two sided t-test c. One sided t-test d. Confidence Interval 11. What is the statistical interpretation? (4 points) a. Average of data is inconsistent with the claim b. P-value...
I. Solve the following problem: For the following data: 1, 1, 2, 2, 3, 3, 3,...
I. Solve the following problem: For the following data: 1, 1, 2, 2, 3, 3, 3, 3, 4, 4, 5, 6 n = 12 b) Calculate 1) the average or average 2) quartile-1 3) quartile-2 or medium 4) quartile-3 5) Draw box diagram (Box & Wisker) II. PROBABILITY 1. Answer the questions using the following contingency table, which collects the results of a study to 400 customers of a store where you want to analyze the payment method. _______B__________BC_____ A...
Part C: Regression and Correlation Analysis Use the dependent variable (labeled Y) and the independent variables...
Part C: Regression and Correlation Analysis Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable. Determine the coefficient of...
4) In order to determine the best-selling style of tennis rackets that are sold in State...
4) In order to determine the best-selling style of tennis rackets that are sold in State College, you have collected data from all sporting goods stores in town. A tennis racket is classified by both its head size and grip size. The Excel sheet “Sales Data Tennis Rackets” in Module 3 contains the data you collected for sales of tennis rackets. Each entry in the Excel sheet represents the sale of one tennis racket. You will have to separate your...