Illustrating Registration Date and Frequency of People – Statistics Assignment Help

By

Assignment Task :

Open excel sheet which is called worksheet “Q1” of the Excel file (provided for this assignment) and develop the following visualizations: (3+3+3=9 marks).

A figure showing whether there is a relationship between age and income.

A figure showing distribution of income.

A figure illustrating registration date and frequency of people who are registered. 

Excel worksheet “Q2” is related to a financial institute that provides loans to its customers. The intention from investigating the data is to identify the customer credibility. The description of variables are presented below:
 
Variable
 
Considering we want to develop a model and consider credibility as a dependent variable answer the following questions: 

How many independent categorical and numerical variables exists in the data set?

If we want to develop a logistic regression model how many coefficients would we have excluding intercept.

 

The data presented in worksheet “Q3” is the results of a 4-year study conducted to assess how age, weight, and gender influence the risk of diabetes. Risk is interpreted as the probability (times 100) that the patient will have diabetes over the next 4-year period. What predictive model you suggest relating risk of diabetes to the person’s age, weight and the gender. Why? (5 marks)

There are 500 client records in the worksheet “Q4” of the Excel file (provided for this assignment) who have shopped many special products from an e-Business website. Each record includes data on types of product purchased (between 1-5), purchase amount ($), age, gender, family size of the customer, whether the client has a membership and whether the customer has a discount card. (8+7=15 marks)

Develop a multiple regression model to predict the spend amount based on other variables in the data set. Write the final equation and interpret the coefficients of the model and explain the accuracy of the model?

What would be your recommendation to improve the accuracy of this model? What is your recommendation to improve the simplicity of the model?  

 
 
This Statistics Assignment  has been solved by our Statistics Experts at TVAssignmentHelp. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services