Problem set 1 solutions Week 2 HW MGMT 650 Fall 2021 Week 2 Homework Questions (Last updated 6/26/2021) Q1 - Grade Calculator Create a spreadsheet that automatically calculates your grade in this...

1 answer below »
please see attached file it has 5 or 6 sheets (tabs) at the bottom


Problem set 1 solutions Week 2 HW MGMT 650 Fall 2021 Week 2 Homework Questions (Last updated 6/26/2021) 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 You are a statistician contracted to sample and analyze weights of the 5 lb bags of coffee. You collect the following data: 5.845.004.485.145.783.986.166.025.524.56 4.335.635.274.255.435.784.575.034.605.00 5.824.235.865.224.895.335.534.725.075.60 5.055.354.285.645.135.565.525.074.305.78 4.794.894.524.534.525.315.275.225.145.20 5.035.395.185.194.455.534.965.445.594.60 4.324.454.915.555.225.654.765.314.395.50 6.094.524.635.224.514.795.504.984.794.51 For all questions, write your answers in the yellow cells. Compute the following statistics using Excel functions so that Excel calculates for you: 1)Mean Median 2)First quartile using QUARTILE.EXC Third quartile using QUARTILE.EXC Interquartile range (IQR) 3)Maximum Minimum Range 4)Variance Standard deviation Coeficient of Variation (CV) 5)For the standard deviation, when do you use STDEV.S and when do you use STDEV.P? 6)Explain why the standard deviation is a better measure to use than the variance. 7)The coefficient of variation (CV) is a measure of relative variability equal to the ratio between the standard deviation divided by the mean, and formatted to %. It is regularly used to compare risk (volatility) in investing, and is especially useful in to compare data on different scales or with different units of measure. Consider weights of 10 oz, 13.4 oz, 15.1 oz with SD of 2.597 oz. The corresponding weights in pounds 0.625 lb, 0.838 lb, 0.944 lb have SD 0.162 lb. The SDs are not equal, yet the sample and its variability are the same. How can we compare variabilities? The CV, unlike other measures of variability, does not depend on the units of measure. The units are divided out in dividing the standard deviation by the mean. For a "rule of thumb", a CV of greater than 5% is considered significant. So, the CV is also used to assess data with no prior history to compare to evaluate any trends. When is the Coefficient of Variation (CV) especially useful? 8)Copy all of the data into cells M1:M80 in order to use Data Analysis Descriptive Statistics. What happens if you don't and instead use B3:K10 for the Input Range? Use the Data Analysis, Descriptive Statistics. Click the Summary Statistics box and put the output at B65. Highlight the mean, median, Standard deviation, Range, Minimum, and Maximum. 9)As a contracted statistician, you have no prior experience with the company's product. The company has no prior process history and data with which to compare the sample to evaluate any trends. The mode is not especially useful for this data, but explain why there is or is not a concern with bag weight in terms of the other measures of central tendency. 10)What statistic should you use to assess variability of the product? Explain why there is or is not a concern with the variability of the product. &D 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 13Frequency
Answered 1 days AfterAug 31, 2021

Answer To: Problem set 1 solutions Week 2 HW MGMT 650 Fall 2021 Week 2 Homework Questions (Last updated...

Franciosalgeo answered on Sep 01 2021
149 Votes
Problem set 1 solutions
Week 2 HW
MGMT 650 Fall 2021
Week 2 Homework Questions
(Last updated 6/26/2021)
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 t
o 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                                                
        Name of Assignment
Franciosalgeo George: Enter the name of assignment in this column
    Maximum Marks
Franciosalgeo George: Enter maximum possible marks in this column. However this column is not required for average calculation
    Marks Achieved
Franciosalgeo George: Enter marks obtained in this column
    Maximum weights
Franciosalgeo George: Franciosalgeo George:
    Weight Achieved    Final Grade
        Discussion 1    3    90    3    3    90
        Homework2    100    90    7.5    3
        Quiz3    100    90    5    1
        Discussion 4    3    90    3    3
         Quiz4    100    90    5    2
        Quiz5     100    90    5    3
        MidTerm Exam    100    90    10    9
        Discussion 7    3    90    3    3
        Quiz7    100    90    5    1
        Quiz 8    100    90    5    1
        Discussion 9    3    90    3    1
        ARTICLE REVIEW    10    90    10    8
        Quiz10     100    90    5    3
        Discussion 11    3    90    3    1
        Homework11    100    90    7.5    7
        FINAL EXAM    100    90    20    15
Q2 - Descriptive Stat
        You are a statistician contracted to sample and analyze weights of the 5 lb bags of coffee. You collect the following data:                                            5.841
                                                    4.331
        5.84    5.00    4.48    5.14    5.78    3.98    6.16    6.02    5.52    4.56        5.825
        4.33    5.63    5.27    4.25    5.43    5.78    4.57    5.03    4.60    5.00        5.051
        5.82    4.23    5.86    5.22    4.89    5.33    5.53    4.72    5.07    5.60        4.791
        5.05    5.35    4.28    5.64    5.13    5.56    5.52    5.07    4.30    5.78        5.025
        4.79    4.89    4.52    4.53    4.52    5.31    5.27    5.22    5.14    5.20        4.322
        5.03    5.39    5.18    5.19    4.45    5.53    4.96    5.44    5.59    4.60        6.095
        4.32    4.45    4.91    5.55    5.22    5.65    4.76    5.31    4.39    5.50        5.003
        6.09    4.52    4.63    5.22    4.51    4.79    5.50    4.98    4.79    4.51        5.629
                                                    4.234
        For all questions, write your answers in the yellow cells.                                            5.346
                                                    4.890
        Compute the following statistics using Excel functions so that Excel calculates for you:                                            5.388
    1)        Mean    5.084                                    4.445
            Median    5.134                                    4.517
                                                    4.479
    2)        First quartile using QUARTILE.EXC    4.602                                    5.271
            Third quartile using QUARTILE.EXC    5.514                                    5.857
            Interquartile range (IQR)    0.912                                    4.284
                                                    4.524
    3)        Maximum    6.157                                    5.183
            Minimum    3.981                                    4.914
            Range    2.175                                    4.635
                                                    5.137
    4)        Variance    0.259                                    4.249
            Standard deviation    0.509                                    5.222
            Coeficient of Variation (CV)    10.0%                                    5.641
                                                    4.528
    5)    For the standard deviation, when do you use STDEV.S and when do you use STDEV.P?                                            5.194
        When your data represents the full population, the STDEV.P function is utilised. When your data is a sample of the full population, the STDEV.S function is employed. STDEV.S calculates the sample standard deviation, which is an unbiased estimate of the population standard deviation calculated by STDEV.P
The squared deviation is divided by the total number of arguments in the STDEV.P function. The squared deviation is divided by the total number of samples -1 in STDEV.S.                                             5.554
                                                    5.220
                                                    5.784
                                                    5.426
    6)    Explain why the standard deviation is a better measure to use than the variance.                                            4.893
        The variance is calculated as the average of the squared deviations from the mean. For the variance, the differences between each point and the mean are first calculated; the results are then square and averaged. Due to this squaring the unit of measurement of variance is  no longer the same as the original data. The standard deviation is the square root of variance and it will have the same unit of measurement as the data and hence much easier to interpret.                                            5.132
                                                    4.520
                                                    4.451
                                                    5.225
                                                    4.505
    7)    The coefficient of variation (CV) is a measure of relative variability equal to the ratio between the standard deviation divided by the mean, and formatted to %. It is regularly used to compare risk (volatility) in investing, and is especially useful in to compare data on different scales or with different units of measure. Consider weights of 10 oz, 13.4 oz, 15.1 oz with SD of 2.597 oz. The corresponding weights in pounds 0.625 lb, 0.838 lb, 0.944 lb have SD 0.162 lb. The SDs are not equal, yet the sample and its variability are the same. How can we compare variabilities? The CV, unlike other measures of variability, does not depend on the units of measure. The units are divided out in dividing the standard deviation by the mean. For a "rule of thumb", a CV of greater than 5% is considered significant. So, the CV is also used to assess data with no prior history to compare to evaluate any trends.                                            3.981
                                                    5.784
                                                    5.331
                                                    5.564
                                                    5.308
                                                    5.530
                                                    5.654
                                                    4.786
                                                    6.157
        When is the Coefficient of Variation (CV) especially useful?                                            4.570
        When comparing two sets of numbers with different units of measurement, the coefficient of variation comes in handy. Even if the means are dramatically different, it is a helpful statistic for comparing the degree of variance from one data series to another.                                            5.530
                                                    5.524
                                                    5.267
                                                    4.960
                                                    4.761
    8)    Copy all of the data into cells M1:M80 in order to use Data Analysis Descriptive Statistics.                                            5.499
                                                    6.024
        What happens if you don't and instead use B3:K10 for the Input Range?                                            5.033
        If I use B3:K10 it will give the summary statistics of B3:B10, E3:E10, …,K3:K10 separately. That is 10 sets of summary statistics.                                            4.724
                                                    5.065
                                                    5.224
                                                    5.440
                                                    5.307
        Use the Data Analysis, Descriptive Statistics. Click the Summary Statistics box and put the output at B65.                                            4.977
        Column1                                            5.519
                                                    4.602
        Mean    5.0838658858                                        5.065
        Standard...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here