Explore BrainMass
Share

Explore BrainMass

    Making Correlation and Regression spreadsheet

    This content was COPIED 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 October 10, 2019, 1:41 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