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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started