HW2

Just need help with part 3, thank you!

Part 2. Refer to the Excel file Cereal data set to complete the following tasks. All results and explanations need to be reported within this Word document after each question. Make sure to use complete sentences when explaining your results. Your results should be formatted and edited. Data Set: Cereals The data set shows the name of different brands of cereals, the manufacturers, the total calories, proteins, sugar, fat, potassium, sodium, location of the shelf in the supermarket, etc. The amount of sugar, protein, etc., is measured in grams (g). Exercise 1: A. Construct a frequency distribution and a bar graph for the cereal manufactures (mfr). Include the relative frequencies. Edit and format the graph and include appropriate labels for the horizontal and vertical axes. Describe your findings in the context of the problem (Include which manufacturer produces the most cereals and least number of cereals in the cereal market). N = Nabisco, K = Kellog’s, Q = Quaker Oats…

Sleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night’s stay at their hotels. One of the activities, “Inspection,” occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using “number of rooms inspected” as the cost driver for inspection costs. A significant component of inspection costs is the cost of the supplies used in each inspection Mary Adams, the chief inspector, is wondering whether inspection labor-hours might be a better cost driver for inspection costs. Mary gathers information for weekly inspection costs, rooms inspected, and inspection labor-hours as follows: Q.Plot the data and regression line for rooms inspected and inspection costs. Plot the data and regression line for inspection labor-hours and inspection costs. Which cost driver of inspection costs would you choose? Explain.

UPDATED – Use this version! From part 2 of this assignment, you know that gestational diabetes affects #+1 percent of the population in our patient’s age group. Many women in this age group have decided to follow a special diet, which is advertised as being especially nutritious for the baby. One  clinic has 53 pregnant women who have elected to follow this diet. Out of these women, #+3 percent of them  have developed  gestational diabetes.  Use a 5% significance level to determine if this rate is higher than the #+1 percent level in the general population.  Show all work and include screen shots of any Excel template pages you use. Include the following.   A formal statement of the null and alternative hypothesis for your test. Make sure to include correct statistical notation for the formal null and alternative, do not just state this in words.    Screen shots of any Excel Template pages you use.   An interpretation of your p-value including A statement saying whether you…

What do you think are the advantages of understanding the development of Process Flow Diagram? Is it necessary for industrial engineers to know the creation of this chart? Why? Answer in 20 sentences.

A survey found that Massachusetts residents spent an average of $861.75 on the lottery, more than three times the U.S. average. A researcher at a Boston think tank believes that Massachusetts residents spend less than this amount. He surveys 100 Massachusetts residents and asks them about their annual expenditures on the lottery. (You may find it useful to reference the t table.)   Click here for the Excel Data File (The Lottery data below is from the excel file) a. Specify the competing hypotheses to test the researcher’s claim.multiple choice 1 H0: μ = 861.75; HA: μ ≠ 861.75 H0: μ ≥ 861.75; HA: μ < 861.75 H0: μ ≤ 861.75; HA: μ > 861.75 b-1. Calculate the value of the test statistic. (Negative value should be indicated by a minus sign. Round final answer to 3 decimal places.) Test statistic=     Lottery 787 605 919 1140 1090 1191 405 795 1050 644 699 518 469 654 708 405 747 791 880 751 795 803 1103 823 765 744…

Background information: Allison collected additional days of data to monitor the process. Steps to monitor using the control charts: Now monitor the process. An additional ten days of data have been collected, see table labeled “1st 10 Days of Monitoring Reservation Processing Time” in the Data File. Develop Xbar and R charts for the 1st 10 days of monitoring. Plot the data for the 1st 10 days on the Xbar and R charts. Is the process in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart.   Now that we have set up the control charts using enough data from a stable process, the 30 days of data, we will monitor the process. While monitoring the process, what will we use as the upper control limit for the R (range) Chart to compare against our new range values? Enter your response to three decimal places. You do not need to include the units (minutes), ONLY the numeric value. USE EXCELL DATA TO GET…

Identify several types of manufacturing companies for which process costing would be an appropriate product-costing system. What characteristics do the products of these companies have that would make process costing a good choice? How is process costing similar and different in a second or later processing department?

Answers for letter d only

STATS 1700  For each of the following studies, make a chart of the four possible correct andincorrect decisions, and explain what each would mean. Each chart should belaid out like Table 6-1, but put into the boxes the possible results, using thenames of the variables involved in the study. (a) A study of whether increasing the amount of recess time improves schoolchildren’s in-class behavior. (b) A study of whether color-blind individuals can distinguish gray shades betterthan the population at large. (c) A study comparing individuals who have ever been in psychotherapy to thegeneral public to see if they are more tolerant of other people’s upsets thanis the general population.MyStatLab Making Sense of S

Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions. Charity # Charity Total Expenses ($) Administrative Expenses (%) Fundraising Expenses (%) Program Expenses (%) 1 American Red Cross 3355147520 3.8 3.9 92.1 2 World Vision 1200410940 3.8 7.6 88.4 3 Smithsonian Institution 1078888839 23.3 2.6 73.7 4 Food For…

Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.

Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.