Final Equation And Interpret The Coefficients of The Model, Maintenance Service Report Writing - Management Assignment Help

Assignment Task -                 
 

QUANTITATIVE QUESTIONS 
1-There are 500 client records in the first worksheet 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. 
a)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?
b)What would be your recommendation to improve the accuracy of this model or improve the simplicity of the model while the accuracy is not significantly impacted?  

2-A company provides maintenance service for washing machines in Victoria. The collected data are presented in the Excel file (second worksheet). 
a)Assume the manager asked you to analyze the data and provide him some insights and recommendations. The report should not exceed 2 pages. 
b)Build a model to predict the repair time for a future booking service that needs to be done by James and it is a Mechanical repair. Do you suggest this service be assigned to the morning shift or afternoon shift? 
c)Which type of repair is more profitable for the company assuming the salary of the repairpersons are the same. 
                                                                    
3-In worksheet 3, a dataset from the blood bank is presented. The data are recorded for apheresis blood donation made by a group of donors of a period of time. The donor ID is unique for each donor. A donor might have donated more than once in this period. At each donation, the blood total protein level of the donor has been recorded. Use the dataset to answer the following questions:
a)There are some missing values for blood type. Think about how you can fill in the missing values. Explain your approach (step by step) and also apply your approach and try to fill the missing value as much as possible. (save the results in an Excel worksheet and name it Question 3 Part a.)
b)Calculate the range of total protein for each blood type. Explain your approach (steps by step). Report them in a worksheet and name it Question 3 Part c. 
c)Is the number of donations higher on Monday compares to it on Friday? 
d)Present two best visualization tool for this data that you think provide useful information? 

5. The data presented in worksheet 4 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. 
a)What predictive model you suggest to relate the risk of diabetes to the person’s age, weight, and gender. Why?
b)Develop an estimated multiple regression model that relates the risk of diabetes to the person’s age, weight, gender, and lifestyle. Present the regression formula as a mathematical equation. Interpret the coefficients of the regression and comment on the strength of the regression.  
c)What is the risk percentage of diabetes over the next 4 years for a 52-year-old woman living in a small town with 80 kg weight?    

6-Matthew has a new job as a business analyst. He plans to invest 15 percent of his annual salary after the tax into a retirement account at the end of every year for the next 25 years. Suppose that annual return is changing 4% function in Excel), and his current salary before tax is 80k which grows 3% per year. The tax will apply as 15% on the salary up to 50k and it is 20% for the salary interval of 50k and 80k and the tax rate will be 25% for the remaining salary more than 80k (for example if his salary will be 105k, he is paying 15% tax on his first 50k and 20% in the next 25 k and 25% on his next 25k of his salary). then:
a)Create a spreadsheet that shows Matthew the balance of retirement account for various levels of annual investments and returns. 
b)If the annual return rate is uncertain and it is between 5% to 9% in any given year (hint: use = =RANDBETWEEN(2,9)/100) what would be the expected value (average) of Matthew balance after 25 years (use the model 10 times then report the average). 
            

7-A company blends two materials: A and B to produce two types of fertilizers. Fertilizer 1 must be at least 50% of A and sells for $65 per kilo gram. Fertilizer 2 must be at least 70% of B and sells for $48 per kilogram. The price of martial A is $10 per 100 kilograms and the price of martial B is $14 per 100-kilo grams if they purchased over 10,000-kilo gram the price will be reduced by 10%. The total budget of the company to spend on raw martial is $2000. 
a)Write the linear optimization model for the company to make the best decision. 
b)Solve the model and present the results and interpret them.
c)Rewrite the model if a 10% discount only applies to the amount purchased over 10000 kilograms (For example if the company purchases 1001 kg of A, the total price is 1000*10+1*9).

This Management Assignment has been solved by our Management Experts at My Uni Paper. 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.