HI6007 Statistics For Business Decisions

0 Download 6 Pages / 1,290 Words 27-07-2021
• Course Code: HI6007
• University: Holmes Institute
• Country: Australia

Question:

Consumer Research, Inc., is an independent agency that conducts research on consumer attitudes and behaviours for a variety of firms. In one study, a client asked for an investigation of consumer characteristics that can be used to predict the amount charged by credit card users. Data were collected on annual income, household size, and annual credit card charges for a sample of 50 consumers. The following data are recorded for Consumer information.

 Income (\$1000s) Household Size Amount Charged (\$) Income (\$1000s) Household Size Amount Charged (\$) 54 3 4016 54 6 5573 30 2 3159 30 1 2583 32 4 5100 48 2 3866 50 5 4742 34 5 3586 31 2 1864 67 4 5037 55 2 4070 50 2 3605 37 1 2731 67 5 5345 40 2 3348 55 6 5370 66 4 4764 52 2 3890 51 3 4110 62 3 4705 25 3 4208 64 2 4157 48 4 4219 22 3 3579 27 1 2477 29 4 3890 33 2 2514 39 2 2972 65 3 4214 35 1 3121 63 4 4965 39 4 4183 42 6 4412 54 3 3720 21 2 2448 23 6 4127 44 1 2995 27 2 2921 37 5 4171 26 7 4603 62 6 5678 61 2 4273 21 3 3623 30 2 3067 55 7 5301 22 4 3074 42 2 3020 46 5 4820 41 7 4828 66 4 5149

Required:

1. Use methods of descriptive statistics to summarize the data. Comment on the findings.
2. Develop estimated regression equations, first using annual income as the in- dependent variable and then using household size as the independent variable. Which variable is the better predictor of annual credit card charges Discuss your findings.
3. Develop an estimated regression equation with annual income and household size as the independent variables. Discuss your findings.
4. What is the predicted annual credit card charge for a three-person household with an annual income of \$40,000
5. Discuss the need for other independent variables that could be added to the model. What additional variables might be helpful

The data set for group assignment you can find on Blackboard in the folder assignment.

1. Draw a histogram for each one of the 11 variables
2. Do descriptive statistics (mean, standard deviation, minimum, maximum) for each one of the 11 variabl
1. For each correlation discuss the results:
• Are they are positive/negatively correlated
• Are they weak or strong correlations
• What is the significance value
• What does the significance value reveal about the data we have used

Required

1. Copy –paste the result from your Excel file to a Word document.
2. Copy-paste ALL the output from all the activities requested in Activity 01 to 03 in Excel and put the answers in the same Word document.
3. Answer all discussion questions requested in Activity 01 to 03 and put the answers in the same Word document.
4. Submit a soft copy of the Excel files used in Excel and the Assignment Word document online under Assignment final submission.

As part of a long-term study of individuals 65 years of age or older, sociologists and physicians at the Wentworth medical Center in upstate New York investigated the relationship between geographic location and depression. A sample of 60 individuals, all in reasonably good health, was selected; 20 individuals were residents of Florida, 20 were residents of New York, and 20 were residents of North Carolina. Each of the individuals sampled was given a standardized test to measure depression.

The data collected follow; higher test scores indicate higher levels of depression. These data are available on the website that accompanies this text in the file named medical1. A second part of the study considered the relationship between geographic location and depression for individuals 65 years of age or older who had a chronic health condition such as arthritis, hypertension, and/or heart ailment. A sample of 60 individuals with such conditions was identified. Again, 20 were residents of Florida, 20 were residents of New York, and 20 were residents of North Carolina. The levels of depression recorded for this study follow. These data are available on the website that accompanies this text in the file named medical2.

Required:

1. Use descriptive statistics to summarize the data from the two studies. What are your preliminary observations about the depression scores
2. Use analysis of variance on both data sets. State the hypotheses being tested in each case. What are your conclusions
3. Use inferences about individual treatment means where appropriate. What are your conclusions.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help (2021) Statistics For Business Decisions [Online]. Available from: https://myassignmenthelp.com/free-samples/hi6007-statistics-for-business-decisions/consumer-characteristics.html
[Accessed 01 December 2022].

My Assignment Help. 'Statistics For Business Decisions' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/hi6007-statistics-for-business-decisions/consumer-characteristics.html> accessed 01 December 2022.

My Assignment Help. Statistics For Business Decisions [Internet]. My Assignment Help. 2021 [cited 01 December 2022]. Available from: https://myassignmenthelp.com/free-samples/hi6007-statistics-for-business-decisions/consumer-characteristics.html.

Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

250 words

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!