Description
In this exercise, you will conduct a simple Linear Regression using SAS and Excel. The student will create a summary report of their analysis and create an informative graphic that is included in a business memorandum that provides a recommendation based on their analysis of the data set.
Our research question is "Is there any relationship between dairy and meat consumption and bone density in this data set?" You need to turn this question into a statistical question that you can answer using this data. You may need to do additional research to inform your recommendation (is there any theory or medical evidence supporting what you found in the data?) Remember, this is just one data set. Is there other data that you could find that would support or not support your findings?
If you need help conducting a Linear Regression in SAS and Excel, you can view the videos listed after this assignment.
DAL5 Video Link Links to an external site. http://is3310videos.com/indirect2.html?video=13
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Surname 1
Current Date
From: Student Name
To:
Instructor (e.g. Dr. Sherman)
Subj: Linear Regression Analysis
Introduction
Hip fracture incidences encounter various people globally. Ideally, the cause of the
problem instigated continuous debate, with numerous scholars claiming that degenerative
bone disease such as Osteoporosis, which weakness skeletal mass increases the risk of
fracture. Presently, more than 200 million people globally have experienced a hip fracture,
resulting to a huge burden on fiscal and health-care resources.
Problem statement
In order to confirm the possibility of rare outcomes of hip fracture incidence, this
research project examines whether dairy and meat consumption influences the rate of hip
fracture.
Research Objective
Research Question
Is there any relationship between dairy and meat consumption, and bone density?
Statistical Question
Does dairy and meat consumption influence bone density?
Research Methodology
Generally, using statistics from Africa, Asia, Europe, Asia, North America, and Latin
America, data from 40 countries on hip fracture incidence, dairy consumption, lactase
persistence SNPs, animal protein consumption and per capita income and references.
Utilizing Excel and SAS, An analysis of linear regression was applied to assess the
relationship between meat and dairy consumption towards bone density.
Surname 2
Presentation of Findings
The analysis findings of data from 40 countries containing information of dairy and
meat consumption, and bone density, were computed and presented in summary tables and
scatter plots to show the correlation between the variables. The output independent variable is
dairy and meat consumption, whereas, bone density is the dependent variable.
Table 1.1 Shows correlation between Hip fracture rates per 100,000 and dairy consumption
for the data set of 40 countries globally. The correlation value is 0.85
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.852238764
R Square
0.726310911
Adjusted R Square
0.719108566
Standard Error
111.8497235
Observations
Intercept
X Variable 1
40
Coefficients
Standard
Error
t Stat
P-value
28.5661493
35.5862439
0.80273
0.427123
-43.4744
100.6067
-43.4744
1.783139656
0.17756649
10.0421
3.04E-12
1.423675
2.142604
1.423675
Lower 95%
Upper
95%
Lower
95.0%
The Table 1.1 a summary output computed using Excel, also visualized in Figure 1.1
Table...