Chat with us, powered by LiveChat QUESTION 1            Use this Excel spreadshee - BonPapers

QUESTION 1            Use this Excel spreadshee

QUESTION 1            Use this Excel spreadsheet to calculate your grade in   this class. It should include the weights of each       graded   assignment, your grade in each assignment, and your final grade. 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.                                      MGMT 650 Grade Calculator:                   QUESTION 2               A   quality characteristic of interest for a rice-bag-filling process is the   weight of the rice in the individual bags. If the bags are under filled, the company may be in violation of the   truth-in-labeling laws. In this   example, the label weight on the package indicates that, on average, there   are 15 pounds of rice in a bag. If the   average amount of rice in a bag exceeds the label weight, the company is   giving away product. Getting an exact   amount of rice in a bag is problematic because of variation in the   temperature and humidity inside the factory, differences in the size of the   rice, and the extremely fast filling operation of the machine (approximately   150 bags a minute). The following   table provides the weight in pounds of a sample of 60 bags produced in one   hour by a single machine:                 15.1 15.3 15.2 14.6 14.8 15.2 15 15.2 15 15.4    15.7 14.8 15.4 15.5 14.9 14.9 14.9 15.3 15.5 15.4    15.1 14.7 15.1 14.6 14.7 15.2 15.4 15.4 14.5 15.5    15.1 14.8 14.9 14.6 14.6 15.4 15 15.3 15.5 14.9    15.2 15.2 15 15.1 14.7 14.7 15.1 15 14.8 14.8    15.15 15.16 15 15.2 15.14 15.01 15.07 15 15.12 15.1                              Find   all of the following answers using built-in Excel functions                   A) Median:                           Mean:                           B)   First quartile:                          Third   Quartile                                       C)   Range. Hint: Use two Excel functions to find the range.                    Interquartile   range. Hint: use two previously calculated numbers.                   Variance                           Standard   deviation                         Coefficient   of variation. Hint: This number is found using two previously calculated   numbers.                                                     Parts   d and e are your chance to show your understanding.       You   are a consultant brought in by the company and given the sample.     What   are your recommendations to the company, based on your reading for this week?                          D. What are the measures   of central tendency for the sample?                                                                    Interpret the measures of central tendency within the context of   this problem. Should the company   producing the rice bags be concerned about the central tendency?                                                                                                                                            E. What are the measure   of variance for this sample?                                                                       Interpret the measures of   variation within the context of this problem. Should the company     producing the rice bags   be concerned about variation?                                                                                                                                                             QUESTION 3     Built-In Excel Functions          Review   Excel help files (and other sources if you wish) and       explain   in your own words:                      A)   The difference between the functions: QUARTILE.INC()       and   QUARTILE.EXC().                                                                                                                                                                                          Which   of the two functions will you get if you use QUARTILE()?                                             B)   The difference between STDEV.S() and STDEV.P();       and   the difference between VAR.S() and VAR.P().                                                                                                                                                                    C)   The difference between the functions, MAX() and MAXA();      and   the difference between AVERAGE() and AVERAGEA()?                                                                                                                                                       D)   Give an example of when you would use the COUNT() function;      and   and example of when you would use the COUNTA() function.        QUESTION  4               4. Frequency Distribution:              Here   is a hypothetical list of the number of caramel popcorn          cans   sold in 50 scout troops in Maryland. Use Excel’s            capability   (=FREQUENCY()) to create a frequency distribution           using 5 bins.                                Number of Caramel popcorn cans sold in each troop       170 105 103 105 148 158 121 130 118 157       159 147 132 100 115 192 158 196 149 140       176 199 174 107 179 183 129 194 119 150       198 171 120 151 163 108 184 134 186 175       180 114 107 107 165 137 184 200 189 103                       MIN   Use the =MIN() function   to find the lowest number of popcorn cans sold.     MAX   Use the =MAX() function   to find the highest number of popcorn cans sold.                     Subtract   the lowest number of cans sold from the highest number of cans sold:       The   range of number of cans sold is:                              Now   divide the range of the cans sold by 5 to find the size that each bin should   be                       Size   of bin is                                 Create   your bins:               Start   with the minimum number of cans sold and add the size of the bins.        Therefore,    plus   is the highest number   that the first bin should be.      The   =FREQUENCY() function uses the highest number of each bin when calculating   the number in each bin.    The   next bin highest number starts with the first bin’s highest number and adds   the size of the bins.     Therefore,   the second bin begins with    and adds the bin size   to get        Continue   adding to get the Bins array for the =FREQUENCY() function.         Follow   the instructions in the youtube videos to use the =FREQUENCY() array   function.       You   know that you have correctly used the =FREQUENCY() function if Excel   automatically puts {} around the function.                   Min   Bins:   Frequency:            Max         QUESTION 5            5.   Use the frequency of the scout troop caramel popcorn cans sold data and   the         bins data from problem 4   to create:                          Number of Caramel popcorn cans sold in each troop      170 105 103 105 148 158 121 130 118 157      159 147 132 100 115 192 158 196 149 140      176 199 174 107 179 183 129 194 119 150      198 171 120 151 163 108 184 134 186 175      180 114 107 107 165 137 184 200 189 103                     A)   A histogram using the data analysis tool. (Don’t forget to check chart output   at the bottom of the      histogram   popup window to put the histogram information that is generated into a   chart.)                      Histogram:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  B)   A Bar Chart:                                                                                                                                                                                                                                                                                                                                                                                                                                                                 C)   A Pie Chart:

Order an Excellent Paper with Bonpapers.com Writing Service

Bonpaper is a Custom Research Paper Writing service based in USA that is Available 24/7 to cater your needs. We have huge experience of writing essays about every possible topic. We have access to the online libraries, peer-journals, and news sites which makes it possible to gather enough data about the topic. 

We provide the plagiarism-free and grammatically perfect essay writing service to our clients. We have written hundreds of essays so far and our clients have gained excellent results as well.

Need Assignment Help?