4.To find the average population of the cities in this spreadsheet, you type =AVERAGE. What is the proper way to type the range that will complete your function?
A | B | C | D | |
1 | Rank | Name | Population | County |
2 | 1 | Charlotte | 885,708 | Mecklenburg |
3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
4 | 3 | Greensboro | 296,710 | Guilford |
5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
6 | 5 | Winston-Salem | 247,945 | Forsyth |
7 | 6 | Fayetteville | 211,657 | Cumberland |
8 | 7 | Cary | 170,282 | Wake, Chatham |
9 | 8 | Wilmington | 123,784 | New Hanover |
10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
11 | 10 | Concord | 96,341 | Cabarrus |
1 / 1 point
Correct
The range is C2:C11. The full AVERAGE function syntax is =AVERAGE(C2:C11). AVERAGE returns an average of values from a selected range. C2:C11 is the specified range.
Related Questions & Answers:
- Fill in the blank: _____ involves the ability to break things down into smaller steps or pieces and work with them in an orderly and logical way. 3.Fill in the blank: _____ involves the ability to break things down into smaller steps or pieces and work with ... Read more...
- A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process? 5.A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a ... Read more...
- Fill in the blank: A problem is an obstacle to be solved, an issue is a topic to investigate, and a _____ is designed to discover information. 3.Fill in the blank: A problem is an obstacle to be solved, an issue is a topic to investigate, and ... Read more...
- Next, you create a slideshow, which includes a data visualization to highlight the Splashtastic sales insights you’ve discovered. You’ve reached which phase of the data analysis process? 5. Scenario 1 continued Next, you create a slideshow, which includes a data visualization to highlight the Splashtastic sales insights ... Read more...
- What is an example of using a metric? Select all that apply. 5. What is an example of using a metric? Select all that apply. 1 / 1 point Using annual profit ... Read more...
- A data analyst might use descriptive column headers in order to achieve what goal? 8. A data analyst might use descriptive column headers in order to achieve what goal? 1 / 1 point Add context to ... Read more...