Essay on Stats Report

Submitted By Aarian-Charania
Words: 1351
Pages: 6
Open Document
Linear Regression Analysis
Aarian Charania
Professor Habibullah
Section: 8am

Introduction
The independent research company Consumer Research, Inc. conducted research and collected data of annual income and household size, and annual credit card charges. In this report I plan find how much our independent variables (household size and income) affects our dependent variable annual credit card charges. By using descriptive statistics such as mean and standard deviation in order to look at each variable separately. After I will use linear regression to compare two or three variables and see how each variable affects one another. In the end I plan to decide which variable is the most effective in predicting annual credit charges. As the research is limited throughout the report suggestions for improvement such as implementation of new independent variables will be included. This will hopefully lead to a improvement in the model which we already have created by using the data given.

Questions
For all three data sets the data is spread significantly. This is due to standard deviation being a huge percentage of the mean. In relation to skewness, all three have different distributions; for example the income data is uniformly distributed. However the household size data is skewed to the right, this means that the mean is greater than its median. The amount charged seems to be normally distributed. Amount charged has the greatest mean and household size has the smallest.
(All data used in this analysis can be found in the appendix)

Amount Charged vs. Annual Income

According to the equation the Y value would be the amount charged (dependent variable) and the X value would be the annual income (independent variable)
Looking at the results of regression we see that the Model is Significant with more than a 95% confidence level. According to the Residual analysis we learn that about 40% of the variation in amount charged comes from annual income.

Amount Charged vs. Household Size

Once again in this equation our Y value would be the amount charged (dependent variable) and the X value is the household size (independent variable). Once again our model is significant with more than a 95% confidence level. According to the residual analysis the household size explains about 60% of the variation in amount charged.

According to the data we found Household size is a better to predict amount charged than Annual income. This is because household size explains about 60% of the variation in amount charged while annual income only explains 40%.

When developing a regression equation using two independent variables my results changed as expected. Would be the new equation.
Looking at the equation the is the predicted Y value for Amount charged, X1 is the first independent variable being Annual Income and X2 represents the second independent variable Household Size. Once again the model is significant with more than a 95% confidence level. Also household size and annual income explain about 80% of the variation in Amount charged.

In order to find the predicted annual credit card charge for a three-person household with an annual income of $40,000 we plug in our values and solve for .

The predicted annual credit charge for this situation would be about $3700 as shown in the equation above.

As mentioned before in the introduction there is always room for improvement in the model, adding new independent variables to the linear regressions tests can do this. One independent variable that could be added is the Average age of the household. This variable will not only be easy to collect it will add some additional information to the model. The second independent variable that could be used is the number of credit cards. The high the amount of credit cards should lead to a higher total amount charged. Not only will it impact the amount charged but it will also be important
Show More

Related Documents: Essay on Stats Report

Ocean Rocket Project

Overheated/Big blast Returned its crew safety back to Earth Crafts stats Attempt 1 Attempt…

Words 551 - Pages 3

Travel: Social Media and Tweet this Stat Essay

com/blog/bid/93634/50-Tweetable-Social-Media-Marketing-Stats-for-2012 Facebook mobile app audience grew 88% (TWEET THIS STAT) Twitter mobile app audience grew 134% (TWEET THIS STAT) Foursquare mobile app audience grew 118% (TWEET THIS STAT) Pinterest is fastest growing social network in 2012 (TWEET THIS STAT) 46% of social media users now connect via a mobile phone (TWEET THIS STAT) 53% compliment brands on social media networks (TWEET THIS STAT) 50% complain about brands on social media networks (TWEET THIS STAT) 14% purchased…

Words 1983 - Pages 8

A Brief Note On Technology

(earnings, sports stats, earthquake readings), in another, a selection of journalistic clichés—and where the two intersect, an article is born. In truth, it’s a little more complicated than that. In engineering their software, Narrative worked with trained journalists to help the software determine an angle. For example, in the case of sports, the algorithm answers key questions like, “Who won the game and by how much? Was it a comeback or a blowout? Any heroics or notable stats?” The program chooses…

Words 809 - Pages 4

Essay Plant Competition

leaves which means it would ultimately be the better competitor than the bean mixed. Bean Biomass | Bean High | Bean Mixed | Mean | 2.179086957 | 2.74425 | Variance | 0.513809083 | 1.511945137 | Observations | 23 | 22 | df | 43 | | t Stat | -1.893943263 | | P(T<=t) two-tail | 0.064972236 | | t Critical two-tail | 2.016692199 | | The significance is to show that this is an example of interspecific competition, which shows that the bean mixed is the better competitor because…

Words 1265 - Pages 6

Food Metropolitan Essays

vegetables, fruits, and chicken. With some samples it was difficult to make this decision. For example convenience, thrift stores, and food stands were not considered to meet these criteria. A team of four members were put together to formulate this report. The recorder was Alicia Witzofsky and the facilitator was Lisa Manis. Each member of the team collected 250 samples from the St. Louis metropolitan area. These samples were compiled into an Excel spreadsheet. The collected data included the individuals…

Words 1154 - Pages 5

Ray Lewis Essay

that defense, always inspiring teammates with their powerful remarks and refusal to give up” (Brubaker 2). Brubaker is right when those two are the leaders of that defense. Stats show that when the ravens had lewis for the first six games they went 5-1 and then Lewis went down and they went 5-5 the rest of the year. That stat alone should show the importance of him to that team. Once the playoffs hit he was healthy and they went on to win the Super Bowl. That there also shows that he is the heart…

Words 1305 - Pages 6

Essay on Eco Nometrics Report

Econometrics report Econometrics 5BUS1059 Tuhin Ahmed 14089754 Word count-1645 Introduction Economic theory suggests that consumption is positively related to income given the function C=c(y). The aim of this report is to see whether the predictions of this theory hold. The predictions that have been raised in terms of this theory are that when disposable income increases consumption will also increase. Hyphothessis The regression was run and obtained the following results to test…

Words 1739 - Pages 7

Dbm 380 Database Environment

importance of being able to track this data. Knowing that your soldiers are fully trained is very important in making sure they can succeed on the battlefield. This type of database would allow supervisors to check training stats, get physical training test average, and generate reports to keep track who is due or behind with training requirements. Due to this having to be a rather large database using…

Words 820 - Pages 4

Week6 Reports Essay

Reports (Week6) 1. Introduction 2. Report Basics 3. Writing your report Reports: Introduction What’s a Report? A systematic report to answer a question. What are the different types of reports? Information Analytical (A report that takes the info and analyze it) Recommendation Reports: Basics Report Formats: Formal Informal Letter Memo Email Refer to Page 403 Writing your report Planning Researching Composing Planning What is my purpose? Who is my audience? What is my purpose? It depends on the…

Words 362 - Pages 2

Juvenile Justice Terminology

Juvenile Justice Terminology and Juvenile Justice Data. TOPIC # 1: According to your text, what is the main goal of the Juvenile Justice system with respect to juvenile offenders? The main focus of the Juvenile Justice system is to rehabilitate juveniles so that they are unlikely to commit the same crime twice or to prevent them from going down a negative path in life. In order for the Juvenile Justice system to separate itself from the adult justice system, they use different terminologies and…

Words 218 - Pages 1