STAT
png
keyboard_arrow_up
School
Temple University *
*We aren’t endorsed by this school
Course
1102
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
png
Pages
1
Uploaded by DeanUniverseStork32
File
Home
Insert
Draw
rage
Layout
Formuias
Data
Review
View
Automate
Developer
Help
rower
PIvot
v
comments
m
—
v
iti
i
v
W
v
A
v
Ilfilj
4
[Times
New
Romar
v][12
v]
AN
==
[;]
D~
ab
Conditional
Formatting
&
Insert
2
v
v
Ej
&‘%
EE
Paste
@~
BE7
=
elOES
A=
@
=
=
$
%
9
i
Format
as
Table
~
B
Delete
~
E
Analyze
=
Sensitivity
=
Add-ins
g
=
e
™
E
B
%R
[iZ
cell
styles
v
fEl
Formatv
=
@
v
Plats
i
Clipboard
N
Font
N
Alignment
N
Number
N
Styles
Cells
Editing
Analysis
Sensitivity
Add-ins
Y
the_data_is_rig...
v
i
fx
M
A
B
€
D
E
F
G
H
|
J
K
L
M
N
o
P
1
Sports
Equipments
Sales
in
2017
2
Equipment
Equipment
ID
January
February
March
April
May
June
July
August
September
October
November
December
L
Total
Trend
3
Balls
1119
§
1,741
$
1926|%
1812|%
1849/S
2208|%
1799(%
1819|%
2112
|%
1829
$§
2514
§
2023
$§
2484
’S
pasiG)
"\
4
Goals
1214
§
1,286
$
1583
$
1,711
§
1574
$
1687
$
1523
§
1573
$§
1424
§
1669
$
1536
$
1632
|
$
2,159
’S
19,357
5
Nets
1182
§
1263
|
$
1368
|8
1479|8
1357|8
1671|%
1276(3
1493|3
1678
|8
1,157
|$
1507
|$
1,529
'
$
1,615
'S
17,393
6
Racquets
1205
$
1,046
$
1693
$§
1938
§
1670
$
1895
$
1776
$§
1608
$
1711
§
1856
$
1,671
$
1,907
$
1,994
'S
20,765
/
7
Rods
and
tackle
1206
$
886
$
121418
139413
1,174|$
1412|$
1291
|$
1325|$
1373
|$
1255
§
1448
§
1423
$
1,534
'S
15,729
/
s
.
8
Sticks,
bats
and
clubs
1195
§
1,772
$
1,761
|
$
1,773
|$§
1927
|
$
1,706
|
$
2290
|
$§
2,160
$
2,556
_‘
$
2496
$
2,161
§
2403
§
2,592
8§
25597
,-/\/M/
9
Total
S
7,994
S
9,545
§
10,107
’
s
9551
’
$
10,579
|
5
9955
‘
3
9978
‘
$
10,854
$
10262
|$
10837
|$§
10917
|$
12,378
|
$
22sSTs
—
—
il
10
Use
a
cell
reference
or
a
single
formula
where
appropriate
in
order
to
receive
full
credit.
Do
not
copy
and
paste
values
or
type
values,
as
you
will
not
receive
full
credit
for
your
answers.
11
1-2.
In
merged
cells
D11-E11,
select
the
data
type
of
"Equipment
ID".
Qualitative-Ordinal
12
3.
In
merged
cells
D12-E12,
select
the
data
type
of
"sales
for
each
month”
Quantitative-Ratio
13
4.
In
merged
cells
D13-E13,
select
the
data
type
of
"Equi
it
Qualitative-Nominal
14
5.
In
cells
O3
through
O8
in
the
table
above,
find
the
total
sales
for
each
equipment.
6.
In
cells
C9
through
N9
in
the
table
above,
find
the
total
sales
for
each
month.
In cell
O9
in
the
table
15
above,
find the
total
sales
for
the
year.
16
7.
In
cells
P3
through
P9
in
the
table
above,
insert
Sparklines.
8.
In
merged
cells
D17-E17,
is
there
any
trend
in
the
data
based
on
the
I
17
line
in
cell
P9?
Yes-sales
went
up
18
9.
In
cell
D18,
find
the
average
sales
per
month
in
2017.
$
1,707.74
19
10.
In cell
D19,
find
the
median
sales
per
month
in
2017.
$
1,674.50
11.
In
merged
cells
D20-E20,
select
the
shape
of
the
data
based
on
the
20
answers
in
cells
D18
and
D19.
21
12.In
cell
D21,
find the
minimum
sales
per
month
in
2017.
22
13.In
cell
D22,
find the
maximum
sales
per
month
in
2017.
23
14.
In cell
D23,
find the
range
of sales
per
month
in
2017.
15.
In
cells
D24
and
D25,
find
Q1
and
Q3,
respectively,
for
the sales
per
25
month
in
2017.
26
16.
In cell
D26,
find the
interquartile
range
per
month
in
2017.
17.
In
cells
D27
through
D31,
find
the
five-number
summary
for
the
sales
per
month
in
2017.
32
18.
In cell
D32,
find
the
standard
deviation
in
sales
per
month
in
2017.
33
19.
In cell
D33,
find the
variance
in
sales
per
month
in
2017.
20.
In cell
F35
through
F40,
construct
a
frequency
table
for
the
total
sales
:
=
B
s
A
Equip
t
Percentage
in
2017
for
each
piece
of
equipment.
35
Balls
36
Goals
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help