Ryder case

Questions

· Linear Regression

STEPS:

1. Identifying the business analysis questions

2. Converting business questions into statistical questions

3. Performing a descriptive analysis of the data

4. Applying formal analysis procedures

5. Developing conclusions and recommendations

6. Identifying unusual outcomes and future analysis

Sections:

· Executive Summary: 1-3 paragraphs, ** Last part written *** identify the problem, indicate your approach to solving it and concisely state conclusion

· Introduction: ~1 Paragraph, intro to the case, project scope.

· BODY: indicate how you developed your conclusions and recommendations

· Part 1: Begin with concise presentation of the question from the business perspective and explain how you conducted the analysis

· Part 2: Define the data set and specify the statistical procedures used

· Include specific statements of statistical models and hypothesis tests

· Results: Discuss the statistical results, indicating how they provide a solution to the case problem

· Include additional observations and extensions of your results

· Identify unusual outcomes, go into detail on the unexplored questions in the study (Questions for future work), might be important enough to justify another study.

· Document the additional questions and suggest how they might be answered and decide whether or not additional work should be taken

· Conclusion

First thing we’re answering:

1. Does the square footage estimates that are already in the database (REC SQRT) differ significantly from the actual data taken in the sample of 80? AKA can we use the already recorded data to decide the tax rate, or do we need to re-measure all the houses with the RAD appraisers (which they may not have the money/resources to do); aka does the Bradford need to send out the RAD appraisers to re- measure all properties, or are the already recorded ones good enough?

(team: don’t use this image in the report, its not necessary, its all explained below.

When performing a t-test, our null hypothesis is that the actual square footage of the properties is statistically equivalent to the measurements already recorded in the database. Our alternative hypothesis is that there is a significant different between the measures. If we reject the null hypothesis, it means that all houses will have to be re-measured. When performing the t-test, we get a P value of .65. means that we do not reject the null and we do not need to re-measure all houses, and we can just use the recorded square footage already in the database. Now, to figure out what the new tax system should be, we are going to use the the recorded square footage data to come to a conclusion.

Second thing we’re answering:

2. Use the sample to estimate the flat tax and tax rate per square foot that should be charged

Dependent variable: tax

Independent variable: recorded square footage

Looking for a formula: tax paid = slope * recorded square footage + y intercept

Before figuring this out, we have to keep in mind that the data given to us gives the taxes paid per property with the discounts factored in. The 10% reduction if the owner lives in the house, and the 10% reduction if the owner is retired must be removed from the data in order to figure out the correct tax rate formula. In addition, when doing the analysis we removed the 3 data points of the unimproved properties