# Create a statistics area to calculate the average, median, low, and high scores for your team.

Conduct an Internet search to identify the data, and in a new file create an Excel table with games dates, your team’s scores, the opponent, and the opponent’s score for each game for the current season or the last season (do not consider ties; include 7 games or more).
In the fifth column, use an IF function to determine if your team won or lost each game – display either Win or Lose.
In the sixth column, use an IF function to calculate by how many points your team won each game or display an empty string by entering “” in the value_if_false argument if your team lost.
Create a statistics area to calculate the average, median, low, and high scores for your team.
Create a summary area to display number of games won and number of games lost. Use Help to learn about the COUNTIF function and use this function to count the number of games won based on the number of Win entries. Use mixed references in the function’s arguments, copy the function, and then edit the second argument of the copied COUNTIF function to calculate the number of games lost.
Highlight data with conditional formatting of choice.
Include a chart of choice relevant for the data and format it appropriately.
Include the URL of where you got the data.
Create a Documentation sheet to include your name, date, and the purpose of the workbook.
Include a footer for all sheets, with you name on the left side, the date code in the center, and the file name code on the right side.
Format the workbook for readability and appeal.

Is this the question you were looking for? If so, place your order here to get started!

#### How should the UK government measure the effectiveness of their advertising campaign?

1. The government has recently announced that new cars and vans powered wholly by petrol and diesel cannot be sold in the UK after 2030. In response, a major car manufacturer intends to shift resources from marketing its petrol...

#### What were the earliest signs of human rights violations? What else is/was happening at the same time?

This can be officially defined as a genocide or not; or A situation that is on the continuum of the stages of genocide Research the situation and write a paper (3000 words) addressing the following issues and questions: Describe...

#### Discuss how does customer leverage affect supplier leverage decisions, but there is no research or limited research on buyer supplier leverage and how it affect firms value.

There is a paper-how does customer leverage affect supplier leverage decisions, but there is no research or limited research on buyer supplier leverage and how it affect firms value. This is the area I would like to research, Is...