Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1.9 - Assignment 1-Exploring data v Gather data You will select the data you wil

ID: 3369676 • Letter: 1

Question

1.9 - Assignment 1-Exploring data v Gather data You will select the data you will use for this assignment. Use data that you would like to know more about and that is readily available to you. Collect 30 pieces of data and enter them in your answer sheet. Some examples are: a.Number of tracks in albums b.Age of Friends (If you select this one, please make sure you have a valid decision to go with this; wanted to know the age of my friends" is not enough, after all they are YOUR friends and you already know them). c Duration of tracks (If you select this one, make sure you use only ONE unit; usually songs are measured in minutes and seconds TWO units. This does not do well in Excel, so either change them to whole minutes or whole seconds) d.Dollars spent (You can select expenses, or any other monetary transaction, If you would like to compare prices of an item, make sure it is a similar item in all retailers you use. For example, looking at the price of similarly equipped 2015 Toyotas Corolla in 30 different retailers) e.industry or work experience, salaries, etc. f Number of hits on a website g Budgets (You can use films, live productions, product manufacturing, etc.) Some useful sources of data are: a. iTunes b Amazon c.Google analytics d Pandora e.Linked-in f Facebook g EBay h.Spotify

Explanation / Answer

DATA:-

NAME

OTHER EARNINGS

CLOTHING ALLOWANCE

VARIOUS

CITY EARNINGS

HOLIDAY

EARNINGS

A

$10,441.81

$0.00

$0.00

$0.00

B

$0.00

$36,670.40

$0.00

$0.00

C

$19,918.29

$650.00

$2,793.67

$0.00

D

$1,138.05

$2,135.76

$1,751.92

$0.00

E

$0.00

$0.00

$0.00

$0.00

F

$2,209.28

$1,862.52

$2,252.42

$0.00

G

$0.00

$301.64

$0.00

$0.00

H

$8,903.51

$0.00

$0.00

$0.00

I

$10,520.28

$1,013.61

$2,793.67

$0.00

J

$7,919.97

$650.00

$2,374.57

$0.00

K

$0.00

$0.00

$0.00

$0.00

L

$2,069.94

$1,850.00

$2,067.83

$0.00

M

$0.00

$0.00

$0.00

$0.00

O

$0.00

$0.00

$700.13

$0.00

P

$24,098.19

$650.00

$2,793.67

$0.00

A

$0.00

$0.00

$0.00

$0.00

B

$0.00

$0.00

$0.00

$0.00

C

$3,720.13

$0.00

$0.00

$0.00

D

$704.34

$700.00

$0.00

$0.00

E

$6,285.50

$0.00

$0.00

$0.00

F

$0.00

$0.00

$0.00

$0.00

G

$0.00

$0.00

$0.00

$0.00

H

$34.77

$1,627.28

$591.56

$0.00

I

$5,476.54

$1,850.00

$2,833.18

$0.00

J

$890.70

$700.00

$0.00

$0.00

K

$4,764.29

$0.00

$0.00

$0.00

L

$7,870.94

$1,850.00

$2,833.18

$0.00

M

$0.00

$0.00

$0.00

$0.00

O

$791.63

$1,850.00

$2,502.71

$0.00

EXPLORING DATA:-

POPULATION:- Emplyee Earnings

Variable:- Name, Other Earnings, Clothing Allowance, Various Earnings, Holiday Earnings

Sample:- 30 randomly selected employees

Type of variable:- Discrete numerical variable

For Other Earnings:-

NAME

OTHER EARNINGS

CLOTHING ALLOWANCE

VARIOUS

CITY EARNINGS

HOLIDAY

EARNINGS

A

$10,441.81

$0.00

$0.00

$0.00

B

$0.00

$36,670.40

$0.00

$0.00

C

$19,918.29

$650.00

$2,793.67

$0.00

D

$1,138.05

$2,135.76

$1,751.92

$0.00

E

$0.00

$0.00

$0.00

$0.00

F

$2,209.28

$1,862.52

$2,252.42

$0.00

G

$0.00

$301.64

$0.00

$0.00

H

$8,903.51

$0.00

$0.00

$0.00

I

$10,520.28

$1,013.61

$2,793.67

$0.00

J

$7,919.97

$650.00

$2,374.57

$0.00

K

$0.00

$0.00

$0.00

$0.00

L

$2,069.94

$1,850.00

$2,067.83

$0.00

M

$0.00

$0.00

$0.00

$0.00

O

$0.00

$0.00

$700.13

$0.00

P

$24,098.19

$650.00

$2,793.67

$0.00

A

$0.00

$0.00

$0.00

$0.00

B

$0.00

$0.00

$0.00

$0.00

C

$3,720.13

$0.00

$0.00

$0.00

D

$704.34

$700.00

$0.00

$0.00

E

$6,285.50

$0.00

$0.00

$0.00

F

$0.00

$0.00

$0.00

$0.00

G

$0.00

$0.00

$0.00

$0.00

H

$34.77

$1,627.28

$591.56

$0.00

I

$5,476.54

$1,850.00

$2,833.18

$0.00

J

$890.70

$700.00

$0.00

$0.00

K

$4,764.29

$0.00

$0.00

$0.00

L

$7,870.94

$1,850.00

$2,833.18

$0.00

M

$0.00

$0.00

$0.00

$0.00

O

$791.63

$1,850.00

$2,502.71

$0.00