BIS 155 Ted has been retired

$4.50

BIS 155 Ted has been retired
Ted has been retired the last few years and has passionately resumed golfing. He has recorded the round…

Description

BIS 155 Ted has been retired

BIS 155 Ted has been retired

A+ Final Exam

Ted has been retired the last few years and has passionately resumed golfing. He has recorded the round number, date, golf course, number of putts, and total score for each round in Excel as shown in the truncated diagram above. After almost three years of data collection and 300+ rounds of golf, Ted decides to analyze the data to determine if he has improved during this time.

Part 1: Ted would like to calculate the average scores for each golf course over the past three years. What Excel tool will allow you to do this? Be sure to specify the exact steps to obtain the desired results.

The best excel tool to use in this case is the average…

Part 2: Based on your response from part 1, what other Excel tool can be used to produce the same results? Again, be sure to specify the exact steps to obtain the desired results.

The other tool that can be used to make the same result is the sum function which can ….  

Part 3: Ted would also like to view only the rounds of golf where he had greater than 32 putts for the round. The number of putts should be displayed from highest to lowest. Please describe the steps to achieve this result.

To select the values that are greater than 32 putts the greater than …

Part 4: To determine if he has improved over the past 3 years, Ted would like to calculate a running average in column F. A running average displays the average for all rounds played to date. For example, the running average in cell F4 should show the average for the total scores for round numbers 1 through 3. Write this formula as if it were in Cell F2. Write the formula so that it may be copied down the column without modification.

(Points : 40)

=if(F1 + F2 + F3)/3 To copy this formula to all other cells, the…