Question
I need help with my lab assignment. I have inserted the Healthdata Excel sheet for this assignment. I have to use that data to answers
I need help with my lab assignment. I have inserted the Healthdata Excel sheet for this assignment. I have to use that data to answers the questions. Here are the directions. Thankyou so much in advance message me if the heathdata didn't go through.
Scroll down to Regression, and click to expand:
To Obtain a Sample Scatter Plot Using Microsoft Excel
One of the first steps in the analysis of the study data is to create a scatter plot that compares the quantitative variables. Create each of the following scatter plots, find Pearson's correlation coefficient, and perform the corresponding linear regression analysis in each case. Detailed instructions follow on the next page.
- Create a scatter plot, find the r value, and perform the regression analysis that compares the patients' average daily blood sugar level to their Hemoglobin A1C level.
- Create a scatter plot, find the r value, and perform the regression analysis that compares the patients' carbohydrate intake to average glucose levels.
- Create a scatter plot, find the r value, and perform the regression analysis that compares the patients' carbohydrate intake to Hemoglobin A1C levels.
- Open the HealthCareData.xlsx file using Excel.
- From the menu, select Insert, and select Scatter from the scatterplot drop-down: A graph will automatically be created - do not worry, we will adjust accordingly.
- Right-click on the resulting graph, and from the menu that appears, click on Select Data:
- Clear out the chart data range so that there is nothing there:
- Under the Legend Entries (Series) area, click Add. In the window that opens:
For the Series name, type in Glucose vs. Hemoglobin For the Series Y values, click on Select Range and highlight the Hemoglobin column. For the Series X values, click on Select Range and highlight the Glucose column.
Click OK.
- Examine the resulting graph. Click on the graph, and add a regression line. To do so, click on Design, Add Chart Element, Trendline, and More Trendline Options.
- In the window that pops up, select the following and then click OK:
- Examine the resulting graph. Copy and paste it below.
- Create two more graphs:
For the Series name, type in carb_intake vs. Glucose For the Series Y values, click on Select Range and highlight the Glucose column. For the Series X values, click on Select Range and highlight the carb_intake column.
For the Series name, type in carb_intake vs. Hemoglobin For the Series Y values, click on Select Range and highlight the Hemoglobin column. For the Series X values, click on Select Range and highlight the carb_intake column.
- Examine the two additional graphs. Copy and paste them below.
To Obtain Linear Regression Using Microsoft Excel
Calculating Regression in Hemoglobin levels versus Glucose levels
- From Data Analysis menu, select Regression. Click OK.
- In the window that pops up, select the following columns of data (not including the headers) for the Input Y Range and Input X Range:
- For the Series Y values, click on Select Range and highlight the Hemoglobin column.
- For the Series X values, click on Select Range and highlight the Glucose column.
- Normal Probability Plots
Make sure that the following are checked:
- Standardized Residuals
Click OK.
- Copy and paste your results below (both the output table and plot). Think about it: Was there a strong relationship indicated? Was there any extreme values that might skew results? How would you use the regression equations generated by the software? Was the regression equation the same when calculated from the scatter plot as it was using the Data Analysis Toolpak? What preliminary conclusions would be supported and what further study indicated?
- Repeat steps 1 and 2 for the studies that investigate carb_intake versus Glucose levels, and carb_intake versus Hemoglobin.
For the Series name, type in carb_intake vs. Glucose For the Series Y values, click on Select Range and highlight the Glucose column. For the Series X values, click on Select Range and highlight the carb_intake column.
For the Series name, type in carb_intake vs. Hemoglobin For the Series Y values, click on Select Range and highlight the Hemoglobin column. For the Series X values, click on Select Range and highlight the carb_intake column.
- Copy and paste your results for both studies below (both the output tables and plots). Think about it: Were there strong relationships indicated? Were there any extreme values that might skew results? How would you use the regression equations generated by the software? Were the regression equations the same when calculated from the scatter plots as they were using the Data Analysis Toolpak? What preliminary conclusions would be supported and what further study indicated?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started