Suppose that you wanted to study the relationship between DIET (measured in calories allowed per day) and WEIGHT LOSS (measured in kilograms, kg) for adult women between the ages of 30 and 40 who are overweight for their height and body structure, and who all weigh roughly the same number of kilograms before undertaking the weight loss program. You want to test your Excel skills on a random sample of these women based on their weight change over the past 4 months to make sure that you can do this type of research. The hypothetical data appear in Fig. 6.35:

Create an Excel spreadsheet and enter the data using DIET (calories allowed per day) as the independent variable (predictor) and WEIGHT LOSS (kg) as the dependent variable (criterion). Underneath the table, use Excel’s ¼correl function to find the correlation between these two variables. Label the correlation and place it underneath the table; then round off the correlation to two decimal places.

(a) create an XY scatterplot of these two sets of data such that:
• top title: RELATIONSHIP BETWEEN DIET AND WEIGHT LOSS • x-axis title: DIET (calories allowed per day)
• y-axis title: WEIGHT LOSS (kg)
• move the chart below the table • re-size the chart so that it is 8 columns wide and 25 rows long • delete the legend • delete the gridlines

(b) Create the least-squares regression line for these data on the scatterplot, and add the regression equation to the chart.

(c) Use Excel to run the regression statistics to find the equation for the leastsquares regression line for these data and display the results below the chart on your spreadsheet. Use number format (two decimal places) for the correlation and three decimal places for all other decimal figures, including the coefficients.

(d) Print just the input data and the chart so that this information fits onto one page. Then, print the regression output table on a separate page so that it fits onto that separate page.

(e) save the file as: DIET3

Transcribed Image Text:

RELATIONSHIP BETWEEN DIET AND WEIGHT LOSS ADULT WOMEN AGES 30-40 DIET (calories allowed per day) WEIGHT LOSS (kg) 900 16.0 1050 12.0 1150 8.0 1275 6.0 1420 3.0 1530 5.5 1610 9.5 1710 2.5 1820 6.0 1875 9.0 1930 6.0 2100 3.0