Statistics 2 for business

Statistics 2 for business

Individual Coursework Assignment 1

This assignment is worth 50% of the overall module mark and consists of 2 parts (Part I and Part II).

Part I. For this part you are required to perform an independent samples t-test using SPSS. Your solution should be word-processed and submitted electronically. Your solution should include any output produced from the analysis, and an account of the methods you used to obtain that output.

The problem:

Data file. Creditpromo
This is a hypothetical data file that concerns a department store’s efforts to evaluate the effectiveness of a recent credit card promotion (in dollars spent by cardholders). To this end, 500 cardholders were randomly selected. Half received an ad promoting a reduced interest rate on purchases made over the next three months. Half received a standard seasonal ad.
Your task is to perform analysis to find out if the type of an advertisement had an impact on the amount of dollars spent by credit holders.

Perform a suitable independent samples t-test on this data.

You should address the following questions, explaining your answers in detail:

(a) What is the population from which this sample was drawn?
(b) What is the purpose of Levene’s Test? – Explain why it is important that Levene’s Test is included in the output for this independent samples t-test

(c) What is the Null hypothesis for Levene’s Test?
(d) Do we accept or reject the null hypothesis for Levene’s Test? – Explain why.
(e) Which of the two t-tests labelled “Equal variances assumed” and “Equal variances not assumed” should we use? – Explain why.

(f) In order to apply the t-test, what assumption do we make about the distribution of the errors?
(g) What is the null hypothesis for the t-test?
(h) Do we accept or reject the null hypothesis for the t-test? – Explain why.

(i) Is it appropriate to use a one-tailed or two-tailed test here? – Explain why.
(j) What overall conclusion can we draw from this output? – include a reference to the minimum difference between the amount of dollars spent by credit holders who received a standard seasonal ad and those who received a promotional ad. that you would expect to find in the population.

Part II. Task Brief

For this coursework part II you are required to solve a regression problem using SPSS. Your solution should be word-processed and submitted electronically. Your solution should include any output produced from the analysis, and a detailed account of the methods you have used, the reasons you have chosen those particular methods, and the conclusions you have drawn.

The problem:

Data file. Car sales.

This data file contains hypothetical sales estimates and list prices for various makes and models of vehicles.

Analysts for a car sales company are aware that sales of cars depend on car prices, and would like to determine the relationship between list prices and sales more precisely. They collect data on list prices (in thousands of monetary units) and sales (thousands of cars) for six weeks.

Produce a suitable graph to investigate the relationship between the two variables, and report your findings.

Perform an appropriate regression analysis in SPSS, to predict sales figures given the price, and write a detailed report of your findings. Your report should address (but not necessarily be confined to) the following questions:

(a) What percentage of the variation in car sales is accounted for by your model?
(b) What is the equation of best fit, and how do you interpret the coefficients in your model?

(c) By how much, on average, can we expect sales to increase if the list price increases by 10 points?
(d) What assumptions are made about the distribution of the data. If you are able to test whether the assumptions appear to be true, report on your results.

(e) On average, what level of sales can we expect when the list price is 10 thousand (of monetary units)?
(f) In a “worst case scenario”, what is the lowest level of sales that we would expect when the temperature is 10 thousand (of monetary units)? (Use a confidence level of 95%.)