You are an organizer for the Golden State 5k, an annual 5k held across several cities in California to raise money for at risk youth. As part of your duties, you track donations, volunteer informa-tion, and race results. This year, you have decided to use Excel to calculate frequency distribution by age and time, calculate vari-ous descriptive statistics, and forecast participation rate as well as donation rate for 2025.

Measure Central Tendency

You want to calculate the frequency distribution of the recorded race times as well as explore the potential relationship between completion time and age. Note that the data used for this exercise is sample data of the larger population.

1. Open e08c1GoldenState5k and save it as e08c1GoldenState5k_LastFirst.

2. Ensure the RaceResults worksheet is active, then use the FREQUENCY function to calculate the frequency distribution of the race results in column D. Place your results in the range G4:G10.

3. Enter a function in cell F22 to calculate the correlation between age (Column C) and race time (Column D).

4. Enter a function in cell G22 to calculate the covari-ance between age and race time.

5. Enter a function in cell H22 to calculate the variance of the ages in the dataset.

6. Enter a function in cell I22 to calculate the standard deviation of the ages in the dataset.

Use the Analysis ToolPak and Forecast Sheet You will use the Analysis ToolPak to create a histogram to visual-ize the ages of the runners observed. You want to use the Analysis ToolPak to complete a single factor ANOVA on volunteer informa-tion by city.

7. Ensure the Analysis ToolPak add-in is active.

8. Use the Analysis ToolPak to create a histogram based on the ages of the runners surveyed. Use the range C3:C53 as the Input Range and F12:F18 as the Bin Range. Ensure that labels, cumulative percentage and chart output are included in the results. Use cell H12 as the Output Range.

9. Make the VolunteerInfo worksheet active.

10. Use the Analysis ToolPak to perform a single factor ANOVA including labels on the range C5:E21. Place the results starting in cell G5. Resize columns G:M as needed.

Perform Trend Analysis

For your last steps, you will create a Forecast Sheet to visualize participation trend and you will add a linear trendline to a scatter plot to visualize growth in donations. You will use the FORECAST. LINEAR function to forecast donations if the goal of 20,000 par-ticipants is reached.

11. Create a Forecast Sheet that depicts year over year growth in participation. Set the Forecast end year as 2025, and place the results on a new worksheet named 2025Forecast. Resize and reposition the chart to fill the range G2:P22. (On a Mac, the Forecast Sheet feature is not available.)

12. Make the Participants worksheet active and create a scatter plot chart that places the Participant observa-tions on the X axis and the Donation dollars on the Y axis. Be sure to add an appropriate chart title.

13. Add a linear trendline to the chart that also shows the Equation and the R-squared value.

14. Enter a function in cell F6 to calculate the intercept of the linear trendline created in the prior step.

15. Enter a function in cell G6 to calculate the Slope of the linear trendline.

16. Enter a function in cell H6 to calculate the RSQ of the linear trendline.

17. Enter a function in cell I6 to calculate the Standard Error.

18. Use the FORECAST.LINEAR function in cell F9 to forecast potential donations once the goal of 20,000 participants is reached. Format the results as Currency.

19. Complete your analysis by adding formulas in the range G9:H9 to calculate the high and low thresh-olds of the forecast. Apply Accounting Number Format to the results in the range F9:H9.

20. Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side.

21. Save and close the workbook. Based on your instructor’s directions, submit e08c1GoldenState5k_LastFirst.

You are an organizer for the Golden State 5k, an annual 5k held across several cities in California to raise money for at risk youth. As part of your duties, you track donations, volunteer informa-tion, and race results. This year, you have decided to use Excel to calculate frequency distribution by age and time, calculate vari-ous descriptive statistics, and forecast participation rate as well as donation rate for 2025.

Measure Central Tendency

You want to calculate the frequency distribution of the recorded race times as well as explore the potential relationship between completion time and age. Note that the data used for this exercise is sample data of the larger population.

1. Open e08c1GoldenState5k and save it as e08c1GoldenState5k_LastFirst.

2. Ensure the RaceResults worksheet is active, then use the FREQUENCY function to calculate the frequency distribution of the race results in column D. Place your results in the range G4:G10.

3. Enter a function in cell F22 to calculate the correlation between age (Column C) and race time (Column D).

4. Enter a function in cell G22 to calculate the covari-ance between age and race time.

5. Enter a function in cell H22 to calculate the variance of the ages in the dataset.

6. Enter a function in cell I22 to calculate the standard deviation of the ages in the dataset.

Use the Analysis ToolPak and Forecast Sheet You will use the Analysis ToolPak to create a histogram to visual-ize the ages of the runners observed. You want to use the Analysis ToolPak to complete a single factor ANOVA on volunteer informa-tion by city.

7. Ensure the Analysis ToolPak add-in is active.

8. Use the Analysis ToolPak to create a histogram based on the ages of the runners surveyed. Use the range C3:C53 as the Input Range and F12:F18 as the Bin Range. Ensure that labels, cumulative percentage and chart output are included in the results. Use cell H12 as the Output Range.

9. Make the VolunteerInfo worksheet active.

10. Use the Analysis ToolPak to perform a single factor ANOVA including labels on the range C5:E21. Place the results starting in cell G5. Resize columns G:M as needed.

Perform Trend Analysis

For your last steps, you will create a Forecast Sheet to visualize participation trend and you will add a linear trendline to a scatter plot to visualize growth in donations. You will use the FORECAST. LINEAR function to forecast donations if the goal of 20,000 par-ticipants is reached.

11. Create a Forecast Sheet that depicts year over year growth in participation. Set the Forecast end year as 2025, and place the results on a new worksheet named 2025Forecast. Resize and reposition the chart to fill the range G2:P22. (On a Mac, the Forecast Sheet feature is not available.)

12. Make the Participants worksheet active and create a scatter plot chart that places the Participant observa-tions on the X axis and the Donation dollars on the Y axis. Be sure to add an appropriate chart title.

13. Add a linear trendline to the chart that also shows the Equation and the R-squared value.

14. Enter a function in cell F6 to calculate the intercept of the linear trendline created in the prior step.

15. Enter a function in cell G6 to calculate the Slope of the linear trendline.

16. Enter a function in cell H6 to calculate the RSQ of the linear trendline.

17. Enter a function in cell I6 to calculate the Standard Error.

18. Use the FORECAST.LINEAR function in cell F9 to forecast potential donations once the goal of 20,000 participants is reached. Format the results as Currency.

19. Complete your analysis by adding formulas in the range G9:H9 to calculate the high and low thresh-olds of the forecast. Apply Accounting Number Format to the results in the range F9:H9.

20. Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side.

21. Save and close the workbook. Based on your instructor’s directions, submit e08c1GoldenState5k_LastFirst.

You are an organizer for the Golden State 5k, an annual 5k held across several cities in California to raise money for at risk youth. As part of your duties, you track donations, volunteer informa-tion, and race results. This year, you have decided to use Excel to calculate frequency distribution by age and time, calculate vari-ous descriptive statistics, and forecast participation rate as well as donation rate for 2025.

Measure Central Tendency

You want to calculate the frequency distribution of the recorded race times as well as explore the potential relationship between completion time and age. Note that the data used for this exercise is sample data of the larger population.

1. Open e08c1GoldenState5k and save it as e08c1GoldenState5k_LastFirst.

2. Ensure the RaceResults worksheet is active, then use the FREQUENCY function to calculate the frequency distribution of the race results in column D. Place your results in the range G4:G10.

3. Enter a function in cell F22 to calculate the correlation between age (Column C) and race time (Column D).

4. Enter a function in cell G22 to calculate the covari-ance between age and race time.

5. Enter a function in cell H22 to calculate the variance of the ages in the dataset.

6. Enter a function in cell I22 to calculate the standard deviation of the ages in the dataset.

Use the Analysis ToolPak and Forecast Sheet You will use the Analysis ToolPak to create a histogram to visual-ize the ages of the runners observed. You want to use the Analysis ToolPak to complete a single factor ANOVA on volunteer informa-tion by city.

7. Ensure the Analysis ToolPak add-in is active.

8. Use the Analysis ToolPak to create a histogram based on the ages of the runners surveyed. Use the range C3:C53 as the Input Range and F12:F18 as the Bin Range. Ensure that labels, cumulative percentage and chart output are included in the results. Use cell H12 as the Output Range.

9. Make the VolunteerInfo worksheet active.

10. Use the Analysis ToolPak to perform a single factor ANOVA including labels on the range C5:E21. Place the results starting in cell G5. Resize columns G:M as needed.

Perform Trend Analysis

For your last steps, you will create a Forecast Sheet to visualize participation trend and you will add a linear trendline to a scatter plot to visualize growth in donations. You will use the FORECAST. LINEAR function to forecast donations if the goal of 20,000 par-ticipants is reached.

11. Create a Forecast Sheet that depicts year over year growth in participation. Set the Forecast end year as 2025, and place the results on a new worksheet named 2025Forecast. Resize and reposition the chart to fill the range G2:P22. (On a Mac, the Forecast Sheet feature is not available.)

12. Make the Participants worksheet active and create a scatter plot chart that places the Participant observa-tions on the X axis and the Donation dollars on the Y axis. Be sure to add an appropriate chart title.

13. Add a linear trendline to the chart that also shows the Equation and the R-squared value.

14. Enter a function in cell F6 to calculate the intercept of the linear trendline created in the prior step.

15. Enter a function in cell G6 to calculate the Slope of the linear trendline.

16. Enter a function in cell H6 to calculate the RSQ of the linear trendline.

17. Enter a function in cell I6 to calculate the Standard Error.

18. Use the FORECAST.LINEAR function in cell F9 to forecast potential donations once the goal of 20,000 participants is reached. Format the results as Currency.

19. Complete your analysis by adding formulas in the range G9:H9 to calculate the high and low thresh-olds of the forecast. Apply Accounting Number Format to the results in the range F9:H9.

20. Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side.

21. Save and close the workbook. Based on your instructor’s directions, submit e08c1GoldenState5k_LastFirst.

Measure Central Tendency

Measure Central Tendency

1. Open e08c1GoldenState5k and save it as e08c1GoldenState5k_LastFirst.

1. Open e08c1GoldenState5k and save it as e08c1GoldenState5k_LastFirst.

4. Enter a function in cell G22 to calculate the covari-ance between age and race time.

4. Enter a function in cell G22 to calculate the covari-ance between age and race time.

5. Enter a function in cell H22 to calculate the variance of the ages in the dataset.

5. Enter a function in cell H22 to calculate the variance of the ages in the dataset.

6. Enter a function in cell I22 to calculate the standard deviation of the ages in the dataset.

6. Enter a function in cell I22 to calculate the standard deviation of the ages in the dataset.

7. Ensure the Analysis ToolPak add-in is active.

7. Ensure the Analysis ToolPak add-in is active.

9. Make the VolunteerInfo worksheet active.

9. Make the VolunteerInfo worksheet active.

Perform Trend Analysis

Perform Trend Analysis

13. Add a linear trendline to the chart that also shows the Equation and the R-squared value.

13. Add a linear trendline to the chart that also shows the Equation and the R-squared value.

15. Enter a function in cell G6 to calculate the Slope of the linear trendline.

15. Enter a function in cell G6 to calculate the Slope of the linear trendline.

16. Enter a function in cell H6 to calculate the RSQ of the linear trendline.

16. Enter a function in cell H6 to calculate the RSQ of the linear trendline.

17. Enter a function in cell I6 to calculate the Standard Error.

17. Enter a function in cell I6 to calculate the Standard Error.