Select Page

Solved by verified expert:please to look the attactment excel are assignmentThe assigned reading for this week should have all the information you need to answer the questions. Also, please review the presentation which I posted last week for a summary of the key concepts that you need for this week.” (See attached)Don’t forget to tab over in the excel sheet.Also, the data analysis toolpack must be active:http://www.j2software.com/excelmini/
week_2___descriptive_statistics_using_excel_functions__1____1_.xlsx_12.xlsx

descriptive_statistics_and_charts.pptx_june_1_2019.pptx

Don't use plagiarized sources. Get Your Custom Essay on
Just from \$10/Page

learnpivottables.pptx_234.pptx

hw2_mgmt650_summer2019_questions__1___2_.xlsx_tf7.xlsx

Unformatted Attachment Preview

bin width=
Outputs
Data
If > 250
observations,
update data
ranges in
orange cells
in Outputs
Do not write
below the data
column(s)
6.0000
5.0000
12.0468
8.9387
10.1228
10.6706
9.7390
8.7580
11.0950
11.9372
10.8821
6.9119
6.5055
9.6738
12.1398
9.8814
9.4306
11.1617
8.6375
11.4584
10.2703
8.7019
11.9806
10.2743
19.5000
Five-Number Summary
Min
5.0000
Q1
8.7299
Median
10.1228
Q3
11.3101
Max
19.5000
bin1
bin2
bin3
bin4
bin5
bin6
Measure of Center
Mean
10.0687
Range
14.5000
IQR
2.5801
Sample Standard Deviation 2.7546
Sample Variance 7.5881
Measure of Shape
Skew
1.2807
12
10
Frequency
Inputs
8
6
4
2
0
2.66
lower limit
5.00
7.66
10.32
12.98
15.63
18.29
upper limit
7.66
10.32
12.98
15.63
18.29
20.95
Center
6.33
8.99
11.65
14.30
16.96
19.62
Count
4
11
9
0
0
1
25
Uses FREQUENCY
function. Note the curly
braces {}.
total
6 Bin Histogram
6.33
8.99
11.65
14.30
Bins
16.96
19.62
bin width=
Outputs
Data
If > 250
observations,
update data
ranges in
orange cells
in Outputs
Do not write
below the data
column(s)
6.0000
5.0000
12.0468
8.9387
10.1228
10.6706
9.7390
8.7580
11.0950
11.9372
10.8821
6.9119
6.5055
9.6738
12.1398
9.8814
9.4306
11.1617
8.6375
11.4584
10.2703
8.7019
11.9806
10.2743
19.5000
Five-Number Summary
Min
5.0000
Q1
8.7580
Median
10.1228
Q3
11.1617
Max
19.5000
bin1
bin2
bin3
bin4
bin5
bin6
Measure of Center
Mean
10.0687
Range
14.5000
IQR
2.4037
Sample Standard Deviation 2.7546
Sample Variance 7.5881
Measure of Shape
Skew
1.2807
12
10
Frequency
Inputs
8
6
4
2
0
2.66
lower limit
5.00
7.66
10.32
12.98
15.63
18.29
upper limit
7.66
10.32
12.98
15.63
18.29
20.95
Center
6.33
8.99
11.65
14.30
16.96
19.62
Count
4
11
9
0
0
1
25
Uses FREQUENCY
function. Note the curly
braces {}.
total
6 Bin Histogram
6.33
8.99
11.65
14.30
Bins
16.96
19.62
DESCRIPTIVE STATISTICS
AND CHARTS
UNIVERSITY OF MARYLAND, UNIVERSITY COLLEGE
DEFINITIONS
â€¢ Descriptive Statistics â€“ summary of a data set.
â€¢ Charts â€“ visual representation of the data set for the group.
DESCRIPTIVE STATISTICAL FUNCTIONS
â€¢ Central Tendency – a way to describe the set of data.
â€¢ arithmetic mean: sum of a list of numbers divided by the number of numbers in the list.
â€¢ Excel uses this function to find the arithmetic mean: =AVERAGE().
â€¢ median: midpoint =MEDIAN().
â€¢ first QUARTILE.INC and third QUARTILE.INC : = Quartile(). Quartiles in statistics are values that
â€¢
An inclusive range of numbers includes all of the numbers in the data set
â€¢
An exclusive does not use the minimum and maximum numbers.
â€¢ Range: Max â€“ Min = Range The range in statistics is a measure of spread.
â€¢ Interquartile range: The IQR is the “interquartile range” of a data set.
â€¢ Standard deviation: =STDEV() the standard deviation is the spread of numbers from the means on the
bell curve.
â€¢
STDEV.S calculates the spread from the means for a sample target population.
â€¢
STDEV.P calculates the spread from the means for an entire target population.
DESCRIPTIVE STATISTICAL FUNCTIONS,
CONâ€™T
â€¢ Variance: =VAR() is equal to the square of the standard deviation for the
â€¢ VAR.S calculates the spread from the means for a sample population.
â€¢ VAR.S calculates the spread from the means for an entire sample population.
â€¢ Coefficient of variation: compares the spread of data sets that have different
units or different means. = (SD/Mean)*100.
FREQUENCY TABLE
â€¢ Frequency table helps us display tally of numerous data observations on
various categories.
â€¢ Need bins:
â€¢ Decide on the number of bins.
â€¢ Max â€“ min = whole number.
â€¢ Whole/bins= interval.
CHARTS
BAR CHART
â€¢ Visual representation of the frequency distribution.
â€¢ Bar Chart: include bins and frequencies.
PIE CHART
â€¢ Shows frequencies and/or percentages.
HISTOGRAM
â€¢ Frequency distribution.
â€¢ Create bins.
â€¢ (Max â€“ Min)/number of required bins = space within the bins.
â€¢ No gaps between bars.
SUGGESTED VIDEOS TO WATCH
â€¢ Descriptive Statistics Function Commands https://www.youtube.com/watch?v=SI4F13FNpiE
â€¢ Descriptive Statistics using ToolPak -https://www.youtube.com/watch?v=ZUqMnb2rRuA
â€¢ Pie, Bar, & Histogram Charts -https://www.youtube.com/watch?v=Ftw0tnEdd20&t=289s
â€¢ Statistics intro: Mean, Median, & Mode:
â€¢ Interquartile range (IQR):
â€¢ Measures of spread: range, variance & standard deviation:
KHAN ACADEMY VIDEOS â€“ PART 2
â€¢ Frequency tables & dot plots: https://www.khanacademy.org/math/prealgebra/pre-algebra-math-reasoning/pre-algebra-frequency-dotplot/v/frequency-tables-and-dot-plots
THE END
â€¢ Be sure to ask questions!
MGMT 650
Statistics for Managerial Decision
Making
Pivot Tables
Pivot Tables
â€¢ Pivot tables are one of Excel’s most powerful
features. A pivot table allows you to extract the
significance from a large, detailed data set.
â€¢ The data set can consist of hundreds or
thousands of records and multiple fields.
â€¢ It is a method of organizing raw data into
contingency tables with values.
2
Pivot Tables
A pivot table is a program tool that allows you to
reorganize and summarize selected columns and rows
of data in a spreadsheet or database table to obtain a
desired report. A pivot table doesn’t actually change
3
Pivot Tables in Excel
â€¢ To create a PivotTable:
â€¢ Select the table or cells (including column
headers) containing the data you want to
use.
â€¢ From the Insert tab, click PivotTable
â€¢ In Create PivotTable dialog box select the
data and the location of the output
â€¢ A blank PivotTable and Field List will
appear on a new worksheet.
4
Pivot Tables
â€¢ Now select fields, filters, totals, etc.
â€¢ Playing with it is the best way to learn it
5
Pivot Tables
6
Videos on Pivot Tables
â€¢ Good Excel help site:
http://www.excel-easy.com/data-analysis/pivottables.html
7
MGMT 650 Summer 2019
Week 2 Homework
(Last updated 3/18/19)
and 3) your final grade. Be sure to label everything: such as the places where the information,
is stored; the names of each assignment; and where to add the actual grades that you receive.
Make this sheet user friendly; especially for users that see the sheet for the first time.
To use this for your benefit, you may want to design it so that it can be used to calculate your interim grade
before you have all the grades. After this week, you will receive the solution from your professor
and you will be able to use your solution or our solution for future classes.
6/2/2019
Here is sample data showing the length of nails in boxes labled 1 1/4 inch. The data is in inches.
1.26
1.24
1.28
1.23
1.21
1.21
1.29
1.21
1)
1.22
1.24
1.25
1.21
1.28
1.22
1.26
1.25
1.27
1.29
1.25
1.23
1.26
1.23
1.26
1.23
1.21
1.24
1.23
1.21
1.25
1.26
1.28
1.25
1.22
1.27
1.26
1.22
1.22
1.28
1.25
1.29
1.25
1.29
1.23
1.22
1.29
1.26
1.24
1.29
1.22
1.23
1.26
1.24
1.22
1.28
1.24
1.22
1.25
1.22
1.29
1.21
1.22
1.21
1.27
1.21
1.25
1.23
1.26
1.23
1.29
1.21
1.28
1.28
1.23
1.26
1.26
1.25
1.24
1.21
1.24
1.27
For the following questions, you must use Excel formulas in the cells so that Excel calculates the answers for you.
Compute the mean:
Compute the median
Find the mode
2)
3)
Compute the first quartile; use =QUARTILE.EXC()
First Quartile
Compute the third quartile; use =QUARTILE.EXC()
Third Quartile
Compute the interquartile range
4)
Find the largest number
Find the smallest number
What is the range?
5)
What is the Variance? Use =VAR.S()
What is the standard deviation? Use =STDEV.S()
6)
What is the Coefficient of Variation, or the CV?
https://www.statisticshowto.datasciencecentral.com/probability-and-statistics/how-to-find-a-coefficient-of-v
7)
When is the Coefficient of Variation especially useful?
Copy all of the data into a column, use Column M and go from cell M1:M80
8)
Use the Data Analysis tool on the numbers just copied to find the Descriptive Statistics:
Click on Data Analysis and Choose Descriptive Statistics
Click on the Summary Statistics box.
Highlight the mean, median, mode, Standard deviation, Range, Minimum, and Maximum
Notice that the Data Analysis tool gives you all of the info needed for this problem except for the quartiles, v
6/2/2019
9)
Interpret the measures of central tendency within the context of this problem.
Should the company producing the nails be concerned about the central tendency?
10)
Interpret the measures of variation within the context of this problem.
Should the company producing the nails be concerned about variation?
6/2/2019
hes.
w-to-find-a-coefficient-of-variation/
except for the quartiles, variance, and CV
6/2/2019
Rank
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
Name
Black Panther
Avengers: Infinity War
Incredibles 2
Jurassic World: Fallen Kingdom
Aquaman
Dr. Seuss’ The Grinch (2018)
Mission: Impossible – Fallout
Ant-Man and the Wasp
Solo: A Star Wars Story
Venom (2018)
Bohemian Rhapsody
A Star is Born (2018)
Ralph Breaks the Internet
A Quiet Place
Spider-Man: Into The Spider-Verse
Crazy Rich Asians
Mary Poppins Returns
Hotel Transylvania 3: Summer Vacation
Fantastic Beasts: The Crimes of Grindelwald
Halloween (2018)
The Meg
Ocean’s 8
Bumblebee
Mamma Mia! Here We Go Again
The Nun
Creed II
Peter Rabbit
The Mule
The Equalizer 2
Rampage (2018)
A Wrinkle in Time
Disney’s Christopher Robin
I Can Only Imagine
Smallfoot
Night School (2018)
The First Purge
Game Night
Book Club
The House With A Clock In Its Walls
Skyscraper
Insidious: The Last Key
Instant Family
Green Book
Blockers
Studio
BV
BV
BV
Uni.
WB
Fox
Uni.
Par.
BV
BV
Sony
Fox
WB
BV
Par.
Sony
WB
BV
Sony
WB
Uni.
WB
WB
WB
Par.
Uni.
WB (NL)
MGM
Sony
WB
Sony
WB (NL)
BV
Uni.
BV
RAtt.
WB
Uni.
Uni.
WB (NL)
Par.
Uni.
Uni.
Uni.
Par.
Uni.
Uni.
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
Pacific Rim Uprising
Tomb Raider
Maze Runner: The Death Cure
The Nutcracker and the Four Realms
Tag
A Simple Favor
Life of the Party
The Predator (2018)
Overboard (2018)
I Feel Pretty
BlacKkKlansman
Red Sparrow
Breaking In (2018)
Goosebumps 2: Haunted Halloween
Vice
12 Strong
Den of Thieves
First Man
Hereditary
Tyler Perry’s Acrimony
Sherlock Gnomes
Uncle Drew
Widows
Truth or Dare
Love, Simon
Second Act
The Commuter
The 15:17 to Paris
Mile 22
Alpha
Peppermint
Death Wish (2018)
The Spy Who Dumped Me
Annihilation
Isle Of Dogs
Nobody’s Fool
The Favourite
Robin Hood (2018)
Super Troopers 2
Slender Man
Holmes and Watson
Teen Titans Go! To The Movies
The Hate U Give
Searching
Winchester
Strangers: Prey at Night
Uni.
WB
Fox
BV
WB (NL)
LGF
WB (NL)
Fox
PNT
Sony
STX
Focus
Fox
Uni.
Sony
Annapurna
WB
STX
Uni.
A24
LGF
Par.
LG/S
Fox
Uni.
WB
Fox
STX
LGF
WB
STX
Studio 8
STX
MGM
LGF
Par.
FoxS
Par.
FoxS
STX
LG/S
Fox
SGem
Sony
WB
Fox
SGem
LGF
Aviron
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
On the Basis of Sex
Focus
White Boy Rick
Studio 8
Won’t You Be My Neighbor?
Focus
Overlord
Par.
Proud Mary
SGem
The Happytime Murders
STX
Superfly
Sony
Show Dogs
Bad Times At The El Royale
Fox
Operation Finale
MGM
Paul, Apostle of Christ
Affirm
Sorry to Bother You
Annapurna
Chappaquiddick
ENTMP
Mary Queen of Scots
Focus
Forever My Girl
RAtt.
Free Solo
NGE
Mortal Engines
Uni.
Hunter Killer
LG/S
They Shall Not Grow Old
WB
The Girl in the Spider’s Web: A New Dragon Tattoo
Sony Story
The Possession of Hannah Grace
SGem
If Beale Street Could Talk
Annapurna
RBG
Magn.
A24
The Darkest Minds
Fox
Three Identical Strangers
Neon
BH Tilt
VPD
The Old Man & the Gun
FoxS
Hell Fest
LGF
Welcome to Marwen
Uni.
The Miracle Season
Mirr/LD
Midnight Sun
Tully (2018)
Focus
The Wife
SPC
Traffik
LGF
Unfriended: Dark Web
BH Tilt
Can You Ever Forgive Me?
FoxS
Early Man
LGF
The Death of Stalin
IFC
Sanju
FIP
Unsane
BST
Beautiful Boy (2018)
Amazon
Mid90s
A24
Dog Days (2018)
LD
Boy Erased
Focus
Hotel Artemis
A.X.L.
Fahrenheit 11/9
Briarcliff
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
Unbroken: Path to Redemption
The Hurricane Heist
Every Day (2018)
Leave No Trace
Death of a Nation
Pandas
God’s Not Dead: A Light in Darkness
Kin
Colette
Simmba
Action Point
Beirut
Gringo
Stan & Ollie
Samson
Johnny English Strikes Again
Gotti
Blindspotting
Burn the Stage: The Movie
Ya Veremos
PFR
ENTMP
Orion
Fox
BST
QF
WB
FUN
PFR
LGF
BST
Relbig.
Par.
BST
STX
SPC
PFR
Uni.
VE
LG/S
Trafalgar
PNT
2 N/A
Life Itself (2018)
Amazon
Sgt. Stubby: An American Hero
Ben is Back
RAtt.
Gosnell: The Trial of America’s Biggest Serial Killer
GVN
Cold War (2018)
Amazon
Indivisible
PFR
The Oscar Nominated Short Films 2018
Shrts.
Disobedience
BST
First Reformed
A24
Juliet, Naked
RAtt.
Electric
7 Days in Entebbe
Focus
2001: A Space Odyssey (2018 re-release)
WB
The Sisters Brothers
Annapurna
Shoplifters
Magn.
Thoroughbreds
Focus
Whitney
RAtt.
Rachel Hollis Presents: Made for More
Fathom
American Animals
Orch.
Free
La Boda de Valentina
PNT
Bharat Ane Nenu
GrtIndia
You Were Never Really Here
Amazon
Suspiria
Amazon
The Rider
SPC
Mary and the Witch’s Flower
GK
195
196
197
198
199
200
Hearts Beat Loud
Papillon (2018)
At Eternity’s Gate
The Fall of the American Empire
Puzzle
G&S
1991 EOne
BST
CBS
EOne
SPC
Total DomesticGross
in Millions
# Theaters Open
Close
\$700,059,566.00
4,084
16-Feb
9-Aug
\$678,815,482
4,474
27-Apr
13-Sep
\$608,581,744
4,410
15-Jun
13-Dec
\$417,719,760
4,485
22-Jun
4-Oct
\$332,063,355
4,184
21-Dec \$318,491,426
4,349
18-May
18-Oct
\$270,620,950
4,141
9-Nov \$220,159,104
4,395
27-Jul
18-Oct
\$216,648,740
4,206
6-Jul
1-Nov
\$213,767,512
4,381
25-May
20-Sep
\$213,515,506
4,250
5-Oct
24-Jan
\$212,393,481
4,000
2-Nov \$210,120,689
3,904
5-Oct \$199,407,849
4,017
21-Nov \$188,024,361
3,808
6-Apr
2-Aug
\$183,890,410
3,813
14-Dec \$174,532,921
3,865
15-Aug
10-Jan
\$170,700,172
4,090
19-Dec \$167,510,016
4,267
13-Jul
29-Nov
\$159,550,370
4,163
16-Nov \$159,342,015
3,990
19-Oct
3-Jan
\$145,443,742
4,118
10-Aug
1-Nov
\$140,218,711
4,145
8-Jun
20-Sep
\$137,690,172
4,234
29-Mar
5-Jul
\$126,680,829
3,597
21-Dec \$120,634,935
3,514
20-Jul
11-Oct
\$117,450,119
3,876
7-Sep
22-Nov
\$115,672,186
3,752
21-Nov \$115,253,424
3,725
9-Feb
14-Jun
\$103,242,064
3,329
14-Dec \$102,084,362
3,388
20-Jul
20-Sep
\$101,028,233
4,115
13-Apr
26-Jul
\$100,478,608
3,980
9-Mar
5-Jul
\$100,407,760
3,768
9-Feb
5-Apr
\$99,215,042
3,602
3-Aug
29-Nov
\$83,482,352
2,894
16-Mar
12-Jul
\$83,240,103
4,131
28-Sep \$77,339,130
3,019
28-Sep
3-Jan
\$69,488,745
3,038
4-Jul
6-Sep
\$69,179,066
3,502
23-Feb
21-Jun
\$68,566,296
3,169
18-May
9-Aug
\$68,549,695
3,592
21-Sep
3-Jan
\$68,420,120
3,822
13-Jul
27-Sep
\$67,745,330
3,150
5-Jan
29-Mar
\$67,363,237
3,426
16-Nov
31-Jan
\$67,210,436
2,648
16-Nov \$60,311,495
3,418
6-Apr
2-Aug
Rating
PG-13
PG-13
PG
PG-13
PG-13
R
PG
PG-13
PG-13
PG-13
PG-13
PG-13
R
PG
PG-13
PG
PG-13
PG
PG
PG-13
R
PG-13
PG-13
PG-13
PG-13
PG-13
R
PG-13
PG
R
R
PG-13
PG
R
PG
PG
PG
PG-13
R
R
PG-13
PG
PG-13
PG-13
PG-13
PG-13
R
Type
SuperHero
SuperHero
Cartoon
Action
SuperHero
SuperHero
Cartoon
Action
SuperHero
Sci-Fi
SuperHero
Drama
Drama
Cartoon
Horror
Cartoon
Comedy
Musical
Cartoon
Fantasy
Horror
Sci-Fi
Action
Sci-Fi
Sci-Fi
Musical
Horror
Drama
Family
Drama
Thriller
Action
Fantasy
Drama
Fantasy
Family
Cartoon
Comedy
Horror
Comedy
Comedy
Fantasy
Action
Horror
Comedy
Drama
Comedy
\$59,874,525
\$58,250,803
\$58,032,443
\$54,858,851
\$54,730,625
\$53,548,586
\$53,059,911
\$51,024,708
\$50,316,123
\$50,072,235
\$48,795,601
\$48,686,605
\$46,874,505
\$46,840,590
\$46,700,633
\$46,400,034
\$45,819,713
\$44,947,622
\$44,936,545
\$44,069,456
\$43,549,096
\$43,242,871
\$42,469,946
\$42,402,392
\$41,411,015
\$40,891,591
\$40,826,341
\$39,278,609
\$36,343,858
\$36,276,286
\$36,108,758
\$35,857,181
\$35,418,723
\$34,017,028
\$33,562,069
\$32,732,301
\$32,015,231
\$31,713,110
\$31,483,582
\$31,445,012
\$30,824,628
\$30,617,396
\$30,569,484
\$30,568,743
\$29,790,236
\$29,719,483
\$26,020,957
\$25,091,816
\$24,586,708
3,708
3,854
3,793
3,766
3,382
3,102
3,656
4,070
2,006
3,055
3,440
1,914
3,064
2,537
3,723
2,534
3,018
2,432
3,640
2,998
2,006
3,662
2,742
2,803
3,068
3,702
2,434
2,607
2,892
3,042
3,520
2,881
2,980
2,882
3,111
2,112
1,947
2,468
1,554
3,015
2,827
2,125
2,358
2,780
3,188
2,375
2,009
2,480
2,464
23-Mar
16-Mar
26-Jan
2-Nov
15-Jun
14-Sep
11-May
14-Sep
4-May
29-Jun
20-Apr
10-Aug
2-Mar
11-May
12-Oct
25-Dec
19-Jan
19-Jan
12-Oct
8-Jun
30-Mar
23-Mar
29-Jun
16-Nov
13-Apr
12-Jan
16-Mar
21-Dec
12-Jan
9-Feb
17-Aug
17-Aug
7-Sep
2-Mar
3-Aug
23-Feb
23-Mar
2-Nov
23-Nov
1-Jun
21-Nov
20-Apr
10-Aug
25-Dec
27-Jul
5-Oct
24-Aug
2-Feb
9-Mar

26-Jul PG-13
31-May PG-13
3-May PG-13
PG
13-Sep R
22-Nov R
2-Aug PG-13
29-Nov R
5-Jul PG-13
20-Sep R
21-Jun PG-13
R
7-Jun R
2-Aug PG-13
20-Dec PG
R
29-Mar R
22-Mar R
3-Jan PG-13
30-Aug R
7-Jun R
14-Jun PG
13-Sep PG-13
R
26-Jul PG-13
15-Mar PG
14-Jun PG-13
PG-13
15-Mar PG-13
12-Apr PG-13
4-Oct R
22-Nov PG-13
1-Nov R
31-May R
27-Sep R
19-Apr R
30-Aug PG-13
20-Dec R
R
2-Aug PG-13
10-Jan PG-13
12-Jul R
1-Nov PG-13
PG-13
11-Oct PG
17-Jan PG-13
15-Nov PG-13
29-Mar PG-13
31-May R
Sci-Fi
Action
Sci-Fi
Drama
Comedy
Thriller
Comedy
Sci-Fi
Comedy
Action
Comedy
Drama
Thriller
Thriller
Comedy
Drama
Drama
Thriller
Drama
Horror
Thriller
Cartoon
Comedy
Thriller
Thriller
Family
Comedy
Comedy
Action
Drama
Action
Thriller
Thriller
Action
Comedy
Sci-Fi
Cartoon
Comedy
Drama
Drama
Action
Comedy
Horror
Comedy
Cartoon
Drama
Thriller
Horror
Horror
\$24,337,682
\$24,011,188
\$22,835,787
\$21,704,844
\$20,877,013
\$20,706,452
\$20,545,116
\$17,857,020
\$17,839,115
\$17,612,099
\$17,560,475
\$17,493,096
\$17,395,520
\$16,468,499
\$16,376,066
\$16,292,980
\$15,951,040
\$15,767,460
\$15,754,392
\$14,841,338
\$14,836,174
\$14,251,300
\$14,017,361
\$13,539,709
\$12,695,691
\$12,320,845
\$11,977,130
\$11,846,060
\$11,277,120
\$11,107,431
\$10,763,520
\$10,230,620
\$9,561,064
\$9,369,755
\$9,231,353
\$9,186,156
\$8,866,745
\$8,694,442
\$8,267,544
\$8,041,828
\$7,909,317
\$7,732,899
\$7 …