+1 (208) 254-6996 essayswallet@gmail.com
  

Statistics 10 questions 

HRMD 620

Week 2

Discussion

(R0617)

Triangle Shirtwaist Company Fire

To understand why employment laws were developed, let’s look at a prominent, tragic incident in labor history. 

1) Read/watch a description of the event. Here are some possible sources:

Small, D. (Editor). (2011, March 20). Remembering the Triangle Shirtwaist fire [Television series episode]. In M. Teel (Producer), CBS News Sunday Morning.  New York, NY:  CBS Interactive Inc.  (This runs about 7 minutes.)

####

Writch, J. (Producer).  (2011).  Triangle fire [DVD].  (This was originally published by PBS, but it isn’t available on the website now. This 1-hour video is running at:

####

Industrial Relations School. (2017). Remembering the 1911 Triangle Factory Fire. Cornell University.

(This has a set of materials about the event.)

https://trianglefire.ilr.cornell.edu/

####

https://www.c-span.org has several programs about this event. Just type “Triangle Shirtwaist Fire” into the search box.

####

You may be able to locate other sources if you have difficulty with the above links.

2) Analyze the material. Note the business reasons that led to the conditions.  Note also the perceptions about employers and employees and the issues of equity, voice, and efficiency.  When you have finished reviewing the material, in the Week 2 discussion forum, post one example of equity, voice, or efficiency illustrated in the event and discuss whether it is an issue today.

3) Please respond to at least one other posting.

Week 2 HW

MGMT 650 Summer 2020 Week 2 Homework Questions (Last updated 7/8/2020)

Q1 – Grade Calculator

Create a spreadsheet that automatically calculates your grade in this class as you enter the grades that you receive.
It should include: 1) the weights of each graded assignment, 2) your grade in each assignment,
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.
To test your calculator, make up grades for all assignments. This will allow you to test it and make sure that you get the correct final grade.
1) “give yourself” 85 on all assignments, make sure the final is 85. Now change all grades to 90 and verify that your final grade is 90.
2) Next change one of the quizzes from 90 to 80, and make sure the final grade is lower.
3) Then change the 80 back to 90 and change the mid term grade to 80. Make sure that the result is different.
MGMT 650 Grade Calculator

Q2 – Descriptive Stat

Here is sample data showing the weight of coffee beans in bags labeled 5 pounds. The data is in pounds.
5.834.825.255.964.594.525.065.675.734.71
5.55.844.825.984.895.394.734.965.594.86
4.944.94.714.995.415.265.134.724.544.58
4.594.624.64.675.134.975.274.935.125.14
5.854.674.915.455.195.144.915.374.895.95
4.765.954.915.814.595.914.914.694.815.41
4.935.314.635.625.845.825.574.615.475.33
4.584.834.735.574.765.55.845.15.635.22
For the following questions, you must use Excel formulas in the cells so that Excel calculates the answers for you.
1)Compute the mean:
Compute the median
Find the mode
2)Compute the first quartile; use =QUARTILE.EXC()
First Quartile
Compute the third quartile; use =QUARTILE.EXC()
Third Quartile
Compute the interquartile range
3)Find the largest number
Find the smallest number
What is the range?
4)What is the difference between the Excel functions, STDEV.P and STDEV.S? (Hint: Use the Excel help files.)
5)What is the Variance number?
What is the standard deviation number?
6)Explain why the standard deviation is a better measure to use than the variance
7)What is the Coefficient of Variation, or the CV?
https://www.statisticshowto.datasciencecentral.com/probability-and-statistics/how-to-find-a-coefficient-of-variation/
When is the Coefficient of Variation especially useful?
Give an example of when you will use Coefficient of Variation in real life. This can be from your work, from the popular press, or from a statistics website
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, variance, and CV.
Compare your answers in the previous sections with what you got here. If there is a difference, you probabkly made a mistake, go bak and check your work.
For questions 9 and 10, you are a consultant who is brought in and given these numbers and asked to generate a
report to management. What would your recommendation be?
These two parts are your chance to show your understanding of the material.
To do a good job (and justify your consultant fees :-)) I would expect at least 1-2 paragpahs on each
9)Interpret the measures of central tendency within the context of this problem.
Should the company producing the coffee be concerned about the central tendency?
10)Interpret the measures of variation within the context of this problems.
Should the company producing the coffee be concerned about variation?

&Dhttps://www.statisticshowto.datasciencecentral.com/probability-and-statistics/how-to-find-a-coefficient-of-variation/

Pivot Table Data

Movie RankDomestic Gross (in millions)RatingType
1$ 999.00PG-13Fantasy
2$ 988.00PGDocumentary
3$ 984.00PG-13Thriller
4$ 984.00UnratedSuperHero
5$ 981.00RFantasy
6$ 979.00PGFantasy
7$ 972.00PGFantasy
8$ 970.00PGFamily
9$ 970.00PGRomance
10$ 957.00PG-13Musical
11$ 956.00RHorror
12$ 953.00PG-13SuperHero
13$ 952.00PGDocumentary
14$ 951.00UnratedSci-Fi
15$ 948.00PG-13Horror
16$ 939.00GDocumentary
17$ 934.00GFamily
18$ 932.00UnratedAction
19$ 932.00PGComedy
20$ 930.00RHorror
21$ 907.00RWestern
22$ 905.00PG-13Romance
23$ 904.00RSci-Fi
24$ 903.00UnratedFamily
25$ 898.00PG-13Horror
26$ 896.00PG-13Sci-Fi
27$ 882.00UnratedCartoon
28$ 878.00UnratedHorror
29$ 875.00UnratedAction
30$ 874.00PGUnknown
31$ 873.00UnratedHorror
32$ 860.00RThriller
33$ 856.00UnratedThriller
34$ 851.00RDrama
35$ 848.00RHorror
36$ 839.00PGThriller
37$ 835.00UnratedDrama
38$ 830.00PG-13Comedy
39$ 829.00RHorror
40$ 824.00RHorror
41$ 821.00RComedy
42$ 819.00RUnknown
43$ 815.00RComedy
44$ 809.00PG-13Documentary
45$ 802.00PGThriller
46$ 798.00PGCartoon
47$ 792.00GFamily
48$ 787.00UnratedFamily
49$ 785.00PGMusical
50$ 775.00PG-13Fantasy
51$ 770.00RComedy
52$ 758.00PGDrama
53$ 755.00PG-13Family
54$ 750.00PG-13Western
55$ 744.00PG-13Thriller
56$ 740.00RAction
57$ 736.00PG-13Thriller
58$ 736.00RThriller
59$ 731.00GCartoon
60$ 721.00PGSci-Fi
61$ 721.00RMusical
62$ 717.00RSci-Fi
63$ 700.00GSci-Fi
64$ 692.00UnratedSuperHero
65$ 684.00PGFantasy
66$ 682.00PG-13Fantasy
67$ 671.00PGAction
68$ 667.00GRomance
69$ 658.00UnratedHorror
70$ 645.00RHorror
71$ 642.00GMusical
72$ 642.00GFamily
73$ 637.00PG-13Thriller
74$ 637.00PG-13Comedy
75$ 634.00PG-13Horror
76$ 632.00UnratedHorror
77$ 629.00UnratedSuperHero
78$ 623.00RDocumentary
79$ 623.00UnratedRomance
80$ 620.00PG-13SuperHero
81$ 615.00UnratedSci-Fi
82$ 612.00UnratedDocumentary
83$ 610.00PGCartoon
84$ 610.00UnratedMusical
85$ 605.00PG-13Action
86$ 600.00GFamily
87$ 594.00PG-13SuperHero
88$ 590.00GFamily
89$ 589.00GFamily
90$ 586.00RMusical
91$ 582.00RUnknown
92$ 581.00RDrama
93$ 571.00PG-13Comedy
94$ 570.00GSci-Fi
95$ 564.00PGDocumentary
96$ 562.00PGUnknown
97$ 556.00PG-13Thriller
98$ 545.00PG-13Thriller
99$ 545.00RThriller
100$ 531.00GFamily
101$ 527.00RHorror
102$ 520.00GFantasy
103$ 503.00GDocumentary
104$ 494.00GSci-Fi
105$ 494.00PG-13Thriller
106$ 485.00PG-13Thriller
107$ 478.00RDrama
108$ 474.00RDocumentary
109$ 474.00PG-13Horror
110$ 470.00RRomance
111$ 453.00RHorror
112$ 449.00PGHorror
113$ 446.00PGUnknown
114$ 445.00PGFamily
115$ 434.00PGSci-Fi
116$ 429.00PGFamily
117$ 423.00RDrama
118$ 401.00GSci-Fi
119$ 398.00RSuperHero
120$ 393.00GFamily
121$ 391.00GMusical
122$ 388.00RAction
123$ 387.00PGRomance
124$ 386.00PG-13Unknown
125$ 381.00GRomance
126$ 380.00PGMusical
127$ 378.00PG-13Family
128$ 378.00RAction
129$ 376.00RSci-Fi
130$ 375.00PGFamily
131$ 364.00PG-13Drama
132$ 352.00PG-13Horror
133$ 335.00PG-13SuperHero
134$ 335.00PG-13Action
135$ 332.00RDocumentary
136$ 326.00GFamily
137$ 321.00PG-13SuperHero
138$ 317.00PG-13SuperHero
139$ 313.00GRomance
140$ 306.00UnratedFantasy
141$ 300.00PGCartoon
142$ 298.00PG-13Thriller
143$ 296.00RThriller
144$ 293.00GComedy
145$ 284.00PGComedy
146$ 278.00GSci-Fi
147$ 269.00RSuperHero
148$ 253.00RDocumentary
149$ 253.00RCartoon
150$ 250.00PG-13Action
151$ 245.00RHorror
152$ 241.00RSuperHero
153$ 233.00RComedy
154$ 230.00RComedy
155$ 228.00PG-13Horror
156$ 224.00PGFamily
157$ 219.00PG-13Western
158$ 218.00RFantasy
159$ 216.00PG-13Fantasy
160$ 202.00GRomance
161$ 202.00RAction
162$ 197.00PG-13Documentary
163$ 194.00PGDrama
164$ 193.00PGAction
165$ 187.00PGAction
166$ 183.00PG-13Cartoon
167$ 182.00GFamily
168$ 181.00GComedy
169$ 171.00PG-13Comedy
170$ 169.00PG-13Documentary
171$ 167.00PG-13Romance
172$ 166.00PG-13Cartoon
173$ 164.00PGRomance
174$ 157.00RCartoon
175$ 130.00PG-13Documentary
176$ 129.00PGComedy
177$ 129.00GFamily
178$ 125.00PG-13Thriller
179$ 106.00PG-13Romance
180$ 82.00PGFamily
181$ 81.00GAction
182$ 79.00RHorror
183$ 79.00RRomance
184$ 78.00RCartoon
185$ 73.00GDocumentary
186$ 70.00PG-13Sci-Fi
187$ 69.00PG-13SuperHero
188$ 69.00GCartoon
189$ 63.00PG-13Drama
190$ 60.00RHorror
191$ 57.00PGDocumentary
192$ 54.00PG-13SuperHero
193$ 36.00PGThriller
194$ 30.00RRomance
195$ 26.00RFantasy
196$ 15.00GDocumentary
197$ 14.00RAction
198$ 4.00RFantasy
199$ 4.00PGDocumentary
200$ 1.00RSuperHero

Q3 – Pivot Table

11)Using the data on the Pivot Table Data Sheet, create a Pivot table showing:
1) The Movie Type, Count of Type, and Sum of Domestic Gross (in millions); columns B and D from the Pivot Table Data Sheet
Have three columns:Movie Type, Count of Type, and Sum of Domestic Gross (in millions)
Format the Sum of Domestic Gross (in millions) Field using $
12)Which type of movie had the highest Domestic Gross Total for 2018?
Which type of movie had the highest number of films made of that type in 2018?
(You might try making more/different pivot tables to learn about the raw data. What do you want to know about
Domestic Movies in 2018?)

Q4 – Frequency

Use the raw Data on the Pivot Table Data Sheet to create a Frequency Chart:
Follow these steps to get the Frequency chart. The following website also has instructions to create bins.
https://www.statisticshowto.datasciencecentral.com/choose-bin-sizes-statistics/
13)Step One: (Find the lowest and highest numbers in the data.) Use the Excel sheet titled Pivot Table Data
What is the Total DomesticGross of the lowest movie sales? Hint – use either =MIN()or just choose the movie at the bottom of the list
What is the Total DomesticGross of the highest movie sales? Hint – use either =MAX()or just choose the movie at the top of the list
Step Two: (Find the range)
Step Three: (Find the bin widths)
Each bin will be :wide. Do not round.
Step Four: (Find the highest number for the first bin by starting with the lowest number in the data set and adding the bin width.)
Start with the minimum number:
Add the width of the bins
This number is the highest number that is used in the first bin.
Excel will use this number when it counts the number of pieces of data in the raw data set that is lower than this number.
Put this number in cell C36 for the first bin.
Step Five: (Find the rest of the highest bin numbers. Start with the highest number in the first bin. Add the bin width. This number is the highest total for bin 2.)
Therefore, the second bin begins withand adds the bin sizeto getPlace this number in cell C37.
Successive bins start with the previous bin’s highest number and adds the width of the bins. The last bin will have the maximum number in the data set as its highest value.
Therefore, continue adding to get the Bins array for the =FREQUENCY() function.
The last bin number in cell C45 will equal the highest Domestic Gross movie total
14)Here are the highest numbers for each bin:
Bins:
15)Follow the instructions in the youtube videos to use the =FREQUENCY() array function.https://www.youtube.com/watch?v=c4b1F4-tv8Q
You know that you have correctly used the =FREQUENCY() function if Excel automatically puts {} around the function.
Don’t forget to push Control-Shift-Enter at the same time to enter the =FREQUENCY function.
Bins:Frequency:
Note: Some versions of Excel treat the last bin a bit differently, so the FREQUENCY function may show the last bin as one higher than it should be.
If you get that, don’t worry about it, we will accept either answer.
https://www.youtube.com/watch?v=c4b1F4-tv8Qhttps://www.statisticshowto.datasciencecentral.com/choose-bin-sizes-statistics/

Q5 – Charts

Copy the Bins and Frequency Data from the Q4 – Frequency sheet
Bins:Frequency:
16)Histogram
Create a Histogram of the Bins and Frequency data by first creating a column Chart and then removing the spaces between the columns.
Format the historgram so there are no spaces between the bars. Histograms do not have spaces and the graph does not become a Histogram until the spaces are removed.
Add a title to the Histogram
Add horizontal and Vertical Axes titles
17)Explain the difference between a histogram and a bar graph:
Give an example of when you will use a histogram or a bar chart
18)
Make a pie chart of the raw frequency data with a title and Legend:
Give an example of when you will use a pie chart