Data analysisPython

Java Python Case inc ：

Ronald Rogers is an entrepreneur and an inventor of novelty gadgets that make housework easier for the average household.

He has been hiring “agents” to sell his inventions for years, and he has been keeping  records about these agents’ age and years of sales experience when they first joined, and each agent’s annual sales performance.

With this data, Rogers wants to develop some insights about what kind of agents to hire to maximise sales of his products.

The record of Age, Years of Experience, and Annual Sales are kept in the Excel file. Answer the questions in this assignment based on this case scenario and data set.

Question 1

Rogers believes that the most suitable way to analyse such data is linear regression. It can provide insights about how Age and Experience may impact an Agent’s Annual

Sales Performance.

a.  Using the relevant variables in this data set, suggest and design 3 regression

models that can be generated for Rogers’ purpose. At least one of these 3 models must be a multiple regression model. For each of the model suggested, clearly state the Dependent Variable and the Independent Variable(s)

b.  Construct each of the 3 models suggested in part (a) by using Excel. Specifically, your answer to this part requires the following for each model:

●    The R2 value

●   The Sig. F value

●   The intercept value for the regression equation

●   The p-value of each independent variable

●   The coefficient of each independent variable

●   The Excel file showing the workings involved to get the values above.

(Step-by-step explanations are not required. The Excel file should show the regression reports generated.

c.  Using the values from your answer to part (b), for the multiple regression model:

●   Evaluate the significance of the model as a whole

●   Evaluate the significance of the relationships in the model.

●   Define the regression equation with style. and notations.

d.  Imagine yourself interviewing at Ronald Rogers for a job as an Agent. Based on the age (20 years old) and the years of experience (1 year), estimate your

Annual Sales Performance using the equation from part (c). Show all workings.

a.

Model 1 Dependent Variable: Independent Variable(s):

Model 2 Dependent Variable: Independent Variable(s):

Model 3 Dependent Variable: Independent Variable(s):

b.

Model 1 The R2 value: The Sig. F value: The Intercept value: The p-value of independent variable 1: The p-value of independent variable 2 (if there is one): The p-value of independent variable 3 (if there is one): The coefficient of variable 1: The coefficient of variable 2 (if there is one): The coefficient of variable 3 (if there is one):

Model 2 The R2 value: The Sig. F value: The Intercept value: The p-value of independent variable 1: The p-value of independent variable 2 (if there is one): The p-value of independent variable 3 (if there is one): The coefficient of variable 1: The coefficient of variable 2 (if there is one): The coefficient of variable 3 (if there is one):

Model 3 The R2 value: The Sig. F value: The Intercept value: Data analysisPython The p-value of independent variable 1: The p-value of independent variable 2 (if there is one): The p-value of independent variable 3 (if there is one): The coefficient of variable 1: The coefficient of variable 2 (if there is one): The coefficient of variable 3 (if there is one):

Remember to submit the Excel/R Script file on Canvas with your answer.

c.

Evaluate the Significance of the Model As a Whole (limit your answer to 30 words):

Evaluate the Significance of Each Relationship in the Model (limit your answer to 50 words):

The Regression Equation of this Model:

d.

Your Age:

Your Years of Experience:

The Estimated Annual Sales Performance (with workings):

Question 2

For one of the simple regression models you have constructed in part (b), do the following:

a.  Use a suitable type of visualisation to present this model. Include an image and a short description in your answer.

b.  Suggest 2 specific insights that are useful to Rogers that are conveyed by using such visualisation. Justify your answers.

c.  Use an unsuitable type of visualisation to present this model. Include an image and a short description in your answer.

d.  Suggest 2 specific reasons for why this type of visualisation is problematic.

a.

An image of a suitable visualization:

A Short Description (limit your answer to 20 words):

b.

Insight #1 (limit your answer to 10 words):

Justification (limit your answer to 30 words):

Insight #2 (limit your answer to 10 words):

Justification (limit your answer to 30 words):

c.

An image of an unsuitable visualization:

A Short Description (limit your answer to 20 words):

d.

Specific Reason #1:

Specific Reason #2:

Question 3

Considering the situation in the case scenario, plus the regression analysis and

visualisation covered in questions 2 and 3, outline Ronald Rogers’ P.A.I.D. process with

specific details. You must describe specifically the problem faced by Rogers, the   analysis that would’ve been carried out, the various insights from the analysis, the prediction, and the visualisation, and the specific decision that Rogers would have made.

Put your answers into the spaces in the following answer template. Adhere to the word count guidelines where applicable