# Making Correlation and Regression spreadsheet

Ask a sample of people if they take vitamins/supplements daily and how many (see data attached). Conduct a regression analysis to determine if age (independent variable) has any effect on the number of vitamins/supplements people take. Use the "Correlation and Regression" spreadsheet. Again, enter data in yellow and read output in blue. Explain your answer.

© BrainMass Inc. brainmass.com October 10, 2019, 1:41 am ad1c9bdddfhttps://brainmass.com/statistics/regression-analysis/making-correlation-and-regression-spreadsheet-345001

#### Solution Preview

See the attached files.

PART C DATA IS IN BLUE AND THE "CORRELATION AND REGRESSION SPREADSHEET" WHICH I SENT TO YOU SHOULT BE USED FOR THIS PART

Ask the same people one more question. Ask if they take vitamins/supplements daily and how many. Conduct a regression analysis to determine if age (independent variable) has any effect on the number of vitamins/supplements people take. Use the "Correlation and Regression" spreadsheet. Again, enter data in yellow and read output in blue. Explain your answer.

Here is the data for the 10 students.

GROUPMedical Student PART ASEX ...

#### Solution Summary

This post shows how to conduct a regression analysis to determine if age (independent variable) has any effect on the number of vitamins/supplements people take. by using the "Correlation and Regression" spreadsheet.