Explore BrainMass
Share

Making Correlation and Regression spreadsheet

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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 December 20, 2018, 5:52 am ad1c9bdddf
https://brainmass.com/statistics/regression-analysis/making-correlation-and-regression-spreadsheet-345001

Attachments

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.

$2.19