Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A tutor solved my question using SPSS, but I can't figure out how they achieved the numbers they did. Results of SPSS: Coefficients Dependent Variable:

A tutor solved my question using SPSS, but I can't figure out how they achieved the numbers they did.

Results of SPSS:

CoefficientsDependent Variable: Sales in thousand dollarsModelUnstandardized coefficientsStandardized coefficientstSignificant PBStandard ErrorBeta1Constant-7.20727.585-0.2610.800Number of Ads13.2481.7500.9407.5680.000Coupon value in $23.3537.3920.3923.1590.012

Explanation:

Results of SPSS:

CoefficientsDependent Variable: Sales in thousand dollarsModelUnstandardized coefficientsStandardized coefficientstSignificant PBStandard ErrorBeta1Constant-7.20727.585-0.2610.800Number of Ads13.2481.7500.9407.5680.000Coupon value in $23.3537.3920.3923.1590.012

Interpretation:

  • The parameter (coefficient) for Ads is Significant P = 0.000
  • The parameter (coefficient) for coupon is Significant P = 0.012/2 = 0.006 and positive.
  • The null hypothesis is rejected and intercept is also not significant.

Those are what I was shown as the answer.

The original question and data are:

Kohl's wishes to investigate the relationship between level of advertising, coupon value and sales. Kohl's advertises several times a month and includes a coupon (in dollars) with each advertisement. The value of the coupon remains the same in a month but varies from month to month. Kohl's expects that the number advertisements and coupon value have a positive impact on sales. In addition, Kohl's expects that the impact of advertisements increases as the coupon value increases.Kohl's collects the sales (in thousands of dollars), number of ads and coupon value for the last one year. The data is in Kohls.sav. Express the model that the company must use, state the null and alternate hypothesis, estimate the model and provide interpretation. When the manufacturer advertises 5 times in a month and includes a $3 coupon, what is the expected sales?

The data is:

Sales Ads CouponValue

110.54 3 4

209.83 13 2

256.74 13 3

157.86 13 1

174.32 8 3

208.69 13 4

178.57 15 1

89.34 3 3

71.58 3 2

295.77 15 3

100.65 8 1

239.03 15 2

My question is could someone walk me through step by step using SPSS to figure out how this other tutor came up with the numbers at the top of the post.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus, Enhanced

Authors: Cynthia Y Young

3rd Edition

1119339510, 9781119339519

More Books

Students also viewed these Mathematics questions

Question

3. Define the roles individuals play in a group

Answered: 1 week ago