Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!