Use IBM SPSS to conduct analysis
toygikiller
BusinessIntelligenceandDataVisualization_2019_INF30004-1-converted.docxBusiness Intelligence and Data Visualization
Assignment Information
Assignment Structure:
This is an individual assignment. To complete the assignment you should
1) Use SPSS to conduct analysis. Analyse the dataset to answer the specific questions presented to you (see the scenario below). Please provide the screenshot for your answers.
2) Interpret the results, and draw conclusions. Write a report for the client (600-800 words).
Data: Please download the data file from Canvas.
Assignment Submission Procedure and Related Information
Please submit your word or PDF through Canvas. Penalties for late submissions apply.
Scenario
You (Nathan Gerard) work as a junior analyst for a large consultancy company. You have been asked by your manager (Gemma Blumenthal) to complete some of the unfinished data analysis work of your senior colleagues. You need to complete the following tasks:
1) Task A: Use SPSS to conduct analysis. Analyze the dataset to answer the specific questions presented to you (see the scenario below). Please provide the screenshot for your answers.
2) Task B: Interpret the results, and draw conclusions. Write a report for the client (600- 800 words).
To: Nathan Gerard
From: Gemma Blumenthal – Advance Analytics Team Leader
Subject: Analysis of Sales and Customers Dear Nathan,
One of our key client, Cinematographia (a leading entertainment corporation) is urgently
awaiting report on their project. I particularly need your expertise in the following:
Project: Cinematographia box office sales
Data on the box office sales of 120 movies are provided, including information about promotional advertisement for the movies and the theatre type. Build a model to predict box office sales. Your model should provide insights into what factors influence sales as well as ability to predict sales for various scenarios.
I look forward to reading your report. Sincerely
Gemma Blumenthal
Assignment instructions
In order to prepare a reply to Gemma’s email, you will need to examine and analyse the dataset thoroughly. The Excel file includes a sheet named “Variables” describing all variables used in other worksheets. The following provide some guidelines to follow:
Project: Developing a multiple regression model
For this analysis, you will need to build a multiple regression model using sales as your dependent measure. Starting with scatter diagrams and correlation analysis to select variables to include in the model. You might need create dummy variables to help you analyze the data, please follow the link (https://www.youtube.com/watch?v=ScV2FOlx41A) to check the steps.
Then, assessing the model for overall significance (F test with alpha set at 0.05). Afterwards, if the overall model is found to be significant, removing variables that are not contributing to any significant change in the dependent variable one at a time (if there are any).
Task A:
Use SPSS to conduct analysis. Analyze the dataset to answer the specific questions. Please provide the screenshot for your answers. In particular, you should at least consider following questions:
a) Which independent variable has the strongest linear relationship with sales?
b) Is your multiple regression model overall significant?
c) If so, which variables do not help you in modelling the dependent variable?
d) Once you’ve built your final model, are there any potential multi-collinearity problems? If so, which variables are they? (If there are collinearity problems between the independent measures, you should firstly remove the variable that has the “least correlation” with the dependent measure, then run the model and assess again).
e) How well does the model explain sales (use R2 in your explanation)?
f) What would be the sales for a movie with 50 radio ads per week, 40 TV ads per week, 2 newspaper ads per week, and which played for 2 weeks in a Lux Theatre? [Note, only
use the values that you have found to be significant (α set at 0.05) contributors to the behaviour of the dependent measure].
Task B:
Cinematographia is urgently awaiting report on their project. Interpret the results, and draw conclusions. Write a report for the client (600-800 words).
