Question

In: Statistics and Probability

CONO 2463 – Business Statistics Chapter 12 Complete the following parts to calculate (by hand) the...

CONO 2463 – Business Statistics

Chapter 12

  1. Complete the following parts to calculate (by hand) the estimated regression equation for x and y.

xi

yi

15

5

12

7

10

9

7

11
  1. Compute the estimated slope (b1).
  1. Compute the estimated intercept (b0).

  1. Write the estimated regression question you have calculated.
  1. A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). Shown below is a portion of an Excel output for regression analysis.

Summary Output

Regression Statistics

Multiple R

0.878

R Square

0.770

Adjusted R Square

0.725

Standard Error

1.644

Observations

7

ANOVA

df

SS

MS

F

Significance F

Regression

1

45.347

45.347

16.783

0.190

Residual

5

13.509

2.701

Total

6

58.857

Coefficients

Standard Error

t Stat

P-value

Intercept

3.58

3.6082

0.992

0.366

Price

41.60

10.1552

4.096

0.190
  1. Write the estimated regression equation from the Excel Output. Using that equation, if the competitor’s price is $0.30, what are the predicted weekly sales?
  1. Conduct the significance test for the relationship between Sales and Competitor’s Price using the t-test (or F-test). Include null and alternative hypotheses, comparison to alpha of 5%, decision and conclusions.

Solutions

Expert Solution

orchestra answered 1 year ago
Next > < Previous

Related Solutions

Calculate the descriptive statistics below for the following data. You should calculate them by hand and...
Calculate the descriptive statistics below for the following data. You should calculate them by hand and show your work. X = [ 6, 0, 13, 10, 7, 16, 13 ] (a) mode (b) median (c) mean (d) 20% trimmed mean (e) range (f) interquartile range (g) sample standard deviation (h) winsorized sample standard deviation
Can a complete solution to Problem 34E from Chapter 15 of the Business Statistics Communicating with...
Can a complete solution to Problem 34E from Chapter 15 of the Business Statistics Communicating with Numbers Textbook (2nd edition), please be provided? An automotive workers union, in conjunction with top management, is negotiating a new hourly pay policy for union workers based on three variables: (1) job class, (2) years with the company, and (3) years as a union member at any company. The goal is to develop an equitable model that can objectively specify hourly pay, thereby reducing...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally distributed. ​(a) Test whether mu 1greater thanmu 2 at the alphaequals0.10 level of significance for the given sample data. ​(b) Construct a 99​% confidence interval about mu 1minusmu 2. Population 1 Population 2 n 25 19 x overbar 46.9 43.1 s 6.9 12.3 ​(a) Identify the null and alternative hypotheses for this test. A. Upper H 0​: mu 1less thanmu 2 Upper H 1​:...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally distributed. ​(a) Test whether μ1>μ2 at the α=0.01 level of significance for the given sample data.​ (b) Construct a 99​% confidence interval about μ1−μ2. Population 1 Population 2 n 29 21 x overbarx 51.1 41.5 s 4.3 14.8 (a) Identify the null and alternative hypotheses for this test. A. H0​: μ1≠μ2 H1​: μ1=μ2 B. H0​: μ1>μ2 H1​: μ1=μ2 C. H0​: μ1=μ2 H1​: μ1≠μ2 D....
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally distributed. ​(a) Test whether mu 1 greater than mu 2 at the a=0.05 level of significance for the given sample data. ​(b) Construct a 95​% confidence interval about mu 1 - mu 2. ​(a) Identify the null and alternative hypotheses for this test. population 1 population 2 n 23 16 x 50.5 41.6 s 6.7 11.7
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally distributed. ​(a) Test whether u1 > u2 at the a=0.01level of significance for the given sample data. ​(b) Construct a 90​% confidence interval about u1-u2 Population 1 Population 2 n 29 22 x overbarx 45.8 43.4 s 4.9 11.7
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally distributed. ​(a) Test whether mu 1μ1greater than>mu 2μ2 at the alphaαequals=0.050.05 level of significance for the given sample data.​(b) Construct a 9595​% confidence interval about mu 1μ1minus−mu 2μ2. Population 1 Population 2 n 2525 1919 x overbarx 47.547.5 40.740.7 s 5.75.7 10.710.7 ​(a) Identify the null and alternative hypotheses for this test. A. Upper H 0H0​: mu 1μ1less than<mu 2μ2 Upper H 1H1​: mu...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally distributed. ​(a) Test whether μ1> μ2 at the alphaα=0.05 level of significance for the given sample data. ​(b) Construct a 99​% confidence interval about μ1−μ2 population1 population2 n 21 19 x bar 48.5 42.3 s 7.1 11.9 (a) Identify the null and alternative hypotheses for this test. A. H0​: μ1 =μ2 H1​: μ1<μ2 B.H0​:μ1 < μ2 H1​:μ1=μ2 C. H0​:μ1>μ2 H1​:μ1= μ2 D. H0​: μ1≠...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally...
Use the given statistics to complete parts​ (a) and​ (b). Assume that the populations are normally distributed. Population 1 Population 2 n=24 n=17 x=47.4 x=42.2 s=6.2 s=9.7 ​(a) Test whether μ1>μ2 at the α=0.05 level of significance for the given sample data. ​ (b) Construct a 99% confidence interval about μ1−μ2.
Statistics - Calculate difference in proportions and chi-square values. Do by hand, not in R or...
Statistics - Calculate difference in proportions and chi-square values. Do by hand, not in R or Excel. Show formulas 1) Calculate difference in proportions 2) Calculate chi-square values Cell phones and cancer Cancer Cancer Cell phone Yes No Yes 53 102 No 485 693
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT