
C. Muse Project 3 REVISED
Mail Print Twitter Facebook
Christine Muse
The data I have chosen is the Alcohol usage in adults found on Stat Crunch website. Data gathered asked individuals questions regarding age, sex, the individual cause to drink, the number of drinks the person drink a week and education. The two quantitative variables I focused on is, the dependent (y) number of drinks consumed and independent (x) the age in a week using a sample size of 100 people.
The formula equation for linear regression is y = b_{0 }+ b_{1}x. In the equation y is the dependent or response is the number of drinks consumed and x is the independent or predictor is the age of individuals. My linear regression equation is 11.4457  0.0987 Age=Average. Since the b_{1} is negative the regression line will go in a downward angle. The linear correlation coefficient, r, is a descriptive measure of the strength and also tell the direction of the linear relationship between two variables. My correlation coefficient is 0.1409, which means my regression line is a weak and negative. The coefficient of determination or Rsquared is 0.0199 and 1.99% the change in y is explained by the regression equation and changes in the independent variable. Although a regression can be done, I can conclude that the regression line should not be done; it is not a good predictor because rsquared is close to 0.
In conclusion, my data focus on the quantitative data with number of drinks consumed by an individual per week (Dependent variable) and the age of said person (independent variable). The linear regression equation is 11.4457  0.0987 Age. The scatterplot shows the data is clustered around the regression line with a few outliers on the chart. My correlation coefficient is 0.1409, which means my regression line is a weak negative. The coefficient of determination or Rsquared is 0.0199 and 1.99% the change in y is explained by the regression equation and changes in the independent variable. Although, the linear regression data can be use it shouldn’t be because the coefficient of determination is close to 0.
Result 1: Simple Linear Regression [Info]
Owner: cmuse28
Size: 174B
Created: Apr 30, 2018
Result 2: Consumption of drinks in Adults by Age [Info]
Owner: cmuse28
Size: 3KB
Created: Apr 4, 2018
Simple linear regression results:
Dependent Variable: No of drinks Independent Variable: Age No of drinks = 11.445749  0.098717052 Age Sample size: 100 R (correlation coefficient) = 0.14091474 Rsq = 0.019856963 Estimate of error standard deviation: 9.5784805
Parameter estimates:
Parameter  Estimate  Std. Err.  Alternative  DF  TStat  Pvalue 

Intercept  11.445749  2.7523425  ≠ 0  98  4.1585482  <0.0001  Slope  0.098717052  0.070059568  ≠ 0  98  1.4090445  0.162 
Analysis of variance table for regression model:
Source  DF  SS  MS  Fstat  Pvalue 

Model  1  182.15567  182.15567  1.9854065  0.162  Error  98  8991.2343  91.747289    Total  99  9173.39    

Data set 1. Alcohol data from adults 3
[Info]
Owner: cmuse28
Source:
Tags:
Description: My group and I design a survey to find out among the adult who drinks , why they drink, their age, education level and how many drink they have per day. The data was gathered individually and put together into statcrunch by one member of the group. This survey shows the number of drinking adults and what motivate them to drink. Our survey question is below.
1. Do you Drink Alcohol? Circle one: Y N
2. What is your age?____years
3. What is your gender? Circle one: Male Female
4. Are you having an increasing number of
A. Financial problems
B. family problems
C. Work problems
D. Health problems
E. Financial and family problems
F financial, health and family problems
G. Family and work problems
H. Financial, Family, and work problems
I. none of the above
Circle one.
5. How many drinks do you have a week?_____ drinks
6. Education: What is the highest degree or level of school you have completed? If currently enrolled, mark the previous grade or highest degree received.
A. No schooling completed
B. Nursery school to 8th grade
C. 9th, 10th or 11th grade
D. 12th grade, no diploma
E. High school graduate  high school diploma or the equivalent (for
example: GED)
F. Some college credit, but less than 1 year
G. 1 or more years of college, no degree
H. Associate degree (for example: AA, AS)
I. Bachelor's degree (for example: BA, AB, BS)
J. Master's degree (for example: MA, MS, MEng, MEd, MSW, MBA)
K. Professional degree (for example: MD, DDS, DVM, LLB, JD)
Circle one.
 Original Message 
Sent on:Tuesday, May 22, 2012 11:46 PM
Hi. It looks good.
Change:
2. What is your gender? Circle one: Male Female Other
to2. What is your gender? Circle one: Male Female Other
Since I do not think you will get someone answering as Other.
In #3, I forgot another option:3. Are you having an increasing number of
A. Financial problems
B. family problems
C. Work problems
D. Financial and family problems
E. financial and family problems
F. Family and work problems
G. Financial, Family, and work problems
H. none of the above
Circle one.
Size: 12KB
Delimiter: whitespace
Last edited: Apr 18, 2018
To analyze this data, please sign in.
HTML link: <A href="https://www.statcrunch.com/5.0/viewreport.php?reportid=77518">C. Muse Project 3 REVISED</A>

Already a member? Sign in.