Measures of central tendency for Alabama, California, Delaware, Florida, and Georgia
Directions
Be sure to cite your sources in proper APA formatting and make sure there are no major grammar, punctuation, or spelling errors.
1.) Pick five of the provided States in the attached Excel file. The States are located on the left, and the data for each State is located to the right. FILE ATTACHED
2.) Use the annual income data associated with the States you selected to find the following measures of central tendency for each State:
mean
median
mode
3.) Use Excel to calculate the mean, median, and mode. Please watch the below video to learn how to use excel to calculate the mean, median, and mode.
4.) Using the Median, Mean and Mode Functions in Excel
In a Microsoft Word document, show all calculations and answer the following question in 150
words:
Identify the central tendency you feel is the most representative of the data and justify your answer.
Measures of Central Tendency
Name
Institutional Affiliation
Measures of Central Tendency
* Measures of central tendency for Alabama, California, Delaware, Florida, and Georgia
State
Annual Incomes Scores
Alabama
3735323440462532423346355424225450532542
California
8088695981827778897149585560413976598393
Delaware
6242304168707089353588684263775522106840
Florida
7466606363647039636671605464656252636463
Georgia
5028494839393926223519485860885459592440
* Mean
Mean is the average annual incomes scores for the state selected, and can be calculated by adding all the values and dividing by the number (n) of observations in the dataset as shown below (Excel Functions, 2010).
x1+x2….+xnn
* Alabama 38.05
* California 69.35
* Delaware 53.75
* Florida 62.3
* Georgia 44.2
* Median
Median annual income scores for the states is the middle score for each state. It is also known as the value that splits the sets into half (Excel Functions, 2010).
👀 Other Visitors are Viewing These APA Coursework Samples:
- Reading Questions. Mathematics & Economics Coursework1 page/≈275 words | No Sources | APA | Mathematics & Economics | Coursework |
- Economics Annotated Bibliography: 2000s Recession1 page/≈550 words | 8 Sources | APA | Mathematics & Economics | Coursework |
- Electricity DC Theory: Series and Parallel Circuits3 pages/≈825 words | No Sources | APA | Mathematics & Economics | Coursework |
- How and Why Inequality Can Ruin Society and Create Problems for Human Beings1 page/≈275 words | 1 Source | APA | Mathematics & Economics | Coursework |
- Making of the budget2 pages/≈550 words | 2 Sources | APA | Mathematics & Economics | Coursework |
- What Factors Make it Difficult to Determine the Unemployment Rate?4 pages/≈1100 words | 5 Sources | APA | Mathematics & Economics | Coursework |
- Importance of Macroeconomics1 page/≈275 words | No Sources | APA | Mathematics & Economics | Coursework |