Excel Take home exam with written report (Statistic)

EVALUATION CRITERIA
Written Report
 Completeness and Correctness
 Presentation: including the clarity of writing, interpretation on the empirical results, clarity and
appropriateness of graphs and tables, the use of notation, introduction/motivation and
conclusion/discussion
 Creativity

 Excel file correctness of results produced by the Excel program plus other aspects: generality, documentation and readability
Problem Description
The financial company Giacometti Holding wants to study which are the factors affecting the monthly home mortgage payment or rent payment of her potential customers. In particular, the financial company Giacometti Holding wants to understand the characteristics of the customers, which monthly pay more.
The purpose of the Giacometti’s management is to offer a new financial product: an insurance to hedge against the risk related to the inability to pay a high monthly home mortgage payment or rent payment, in case of a temporary job loss.
As a consultant of the company you are required to suggest a strategy (on which customers do I have to concentrate my attention) to attach the potential market.
The dataset file
The file Data_exam.xlsx contains data from a survey of 500 randomly selected potential customers/householders.
Data Description:
1. Customers/householder: Sequential number.
2. Family size: Number of persons in the family.
3. Location: Location of residence within the given city: 1=SW sector, 2=NW sector, 3=NE sector, and
4=SE sector.
4. Ownership: 0= rent home (house or apartment) or 1=own home.
5. First Income: Annual income of first household wage earner.
6. Second Income: Annual income of second household wage earner (if applicable).
7. Monthly Payment: monthly home mortgage payment or rent payment.
8. Utilities bill: Average monthly expenditure on utilities.
9. Debt: Total indebtedness (excluding home mortgage) in dollars.
STEP 1 (30 points) Create a sample.
￼￼￼￼
Create a sample of 150 customers using the simple random sampling method . Then, all your elaborations must be performed on the sample you create.
Report the main descriptive statistics and draw histograms for the following variables :
1. Family size
2. First Income
3. Second Income
4. Monthly Payment
5. Utilities bill
6. Debt
-Estimate the 99% confidence intervals for the Average Monthly Payment and average debt.
-What proportion of the householders contains a single person. Estimate 99% confidence intervals and test the hypothesis that the population proportion is 20%. Determine the sample dimension to reduce the margin error of the proportion by 50%
-Use Pivot tables to answer the following questions, considering your sample: what are the average monthly payment, average monthly utilities bill, average debt (excluding the home mortgage) of the householders residing in each of the four sectors of the city. Discuss the results
STEP 2 (30 points)
Focus now on the monthly payment as your dependent variable.
Use scatter plots to understand the relevant relationships between the dependent variable and the independent ones, such as the ones reported in “The dataset file” paragraph.
Run a multivariate regression, using as dependent variable the total amount spent and as independent ones independent the ones reported in the bullet points 1-9 above in “The dataset file” paragraph.
Critically comment the significance tests on the beta coefficients, the R^2 and the F-test. Develop a strategy to select only the relevant variables.
Using the regression output, determine with of the explanatory variables should be excluded from the regression equation.
What are the main insights from your analysis?

STEP 4 (30 points)
The Consumer Confidence Index (CCI) attempts to measure people’s feelings about general business conditions, employment opportunity and their own income prospects. The file contains the monthly average of CCI.
Use the forecasting method that you consider more appropriate to forecast the next 6 months. Provide motivations for your choice. Can you use this additional information to add some comments for Giacometti Holding?

Our Service Charter

1. Excellent Quality / 100% Plagiarism-Free

We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
2. Free Revisions

We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
3. Confidentiality / 100% No Disclosure

We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
4. Money Back Guarantee

If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.

We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.

Excellent Quality
Zero Plagiarism
Expert Writers

or