Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. a marketing manager for country kitchen corporatio

A marketing manager for Country Kitchen Corporation (CKC), which sells snack food product \"Nature -Bar\" in...

Free

50.1K

Verified Solution

Question

Statistics

A marketing manager for Country Kitchen Corporation (CKC), whichsells snack food product \"Nature -Bar\" in dif- ferent regions, wasinterested in how its sales (denoted Sales) are influenced by thesales of its main competitor (denoted Csales.) She gathered lastyear data on Sales and Csales for a 15 randomly selected salesregions and ob- tained the regression model of Sales on Csales.Both Sales and Csales are measured in millions of dollars. Toanswer questions below use your own Minitab output.

The data are in Excel file Nature-Bar.

a) Is the regression of Sales on Csales statisticallysignificant at a= 0.02? (State the hypothesis test, rejection ruleand your conclusion)

Region

Sales

Advertising

Promotions

Csales

Selkirk

101.8

1.3

0.2

20.4

Csales=main competitor's sales

Susquehanna

44.4

0.7

0.2

30.5

Sales=sales of company's Nature -Bar

Kittery

108.3

1.4

0.3

24.6

Acton

85.1

0.5

0.4

19.6

Finger Lakes

77.1

0.5

0.6

25.5

Berkshires

158.7

1.9

0.4

21.7

Central

180.4

1.2

1

6.8

all variables are in millions of dollars

Providence

64.2

0.4

0.4

12.6

Nashua

74.6

0.6

0.5

31.3

Dunster

143.4

1.3

0.6

18.6

Endicott

120.6

1.6

0.8

19.9

Five-Towns

69.7

1

0.3

25.6

Waldeboro

67.8

0.8

0.2

27.4

Jackson

106.7

0.6

0.5

24.3

Stowe

119.6

1.1

0.3

13.7

Answer & Explanation Solved by verified expert
4.3 Ratings (579 Votes)

Regression Analysis
r² 0.390 n   15
r   -0.625 k   1
Std. Error   30.932 Dep. Var. Sales
ANOVA table
Source SS   df   MS F p-value
Regression 7,966.4886 1   7,966.4886 8.33 .0128
Residual 12,438.5207 13   956.8093
Total 20,405.0093 14  
Regression output confidence interval
variables coefficients std. error    t (df=13) p-value 95% lower 95% upper std. coeff.
Intercept 177.7012 0.000
Csales -3.5446 1.2284 -2.885 .0128 -6.1984 -0.8908 -0.625

The regression equation is Sales = 177.7012 - 3.5446 * Csales

Hypotheses: β1 = 0 versus Ha: β1 ≠ 0

Critical t- score (α = 0.02, Df = 13) = ± 2.6503

p- value = 0.0128

Since 0.0128 < 0.02, we reject Ho

Conclusion: Sales is significantly affected by Csales.
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Management Accounting Question 1 - Identify two products you purchased in the last year—one for under $5...

Accounting
Q

Oxygen dissociation curve exit ticket The graph below shows the oxygen dissociation curve at a...

Biology
Q

A baseball supply store has many inexpensive baseball gloves. In fact, over half of the...

Basic Math
Q

Unit 6 Lesson 10 A rotation takes P to Q What could be the measure...

Algebra
Q

15 through 4 4 and 0 3 17 through 2 4 and 1 3 16...

Algebra
Q

Part I: A Comprehensive Accounting Cycle Program On December 1, 2009, John and Patty Driver...

Accounting
Q

TF: Under the last -- in, first -- out (LIFO)method, the cost of goods sold...

Accounting
Q

Oslo Company prepared the following contribution format income statement based on a sales volume of...

Accounting
Q

Your company has purchased a large new trucktractor for over-the-road use (asset class 00.26). It...

Accounting
Q

thanks in advance please provide answer as early as possible The six phases...

Accounting
Q

How is the balance sheet used to record amortization and why might it be useful...

Accounting
Q

Exercise 12-71 (Algorithmic) Stockholder Ratios Financial statements for Remington Inc. follow. ...

Accounting