M8A HW

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…

need evaluation steps

Alert for not submit AI generated answer. I need unique and correct answer. Don't try to copy from anywhere. Do not give answer in image formet and hand writing

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…

• Open RStudio. • Open a new R Script. • Copy and paste the below code in R. (to present your answer for this task, take a screenshot of your RStudio session, and paste it into your assessment solutions document). • Run the code, then copy and paste the outputs and the graphs into your assessment solutions document. • Copy and paste the code in your assignment and use comments to explain each line of the code. Note: to get help in R, highlight the code and press F1. Code to be copied and pasted into an R script in RStudio: Treatment <- rep (c("Level_1", "Level_2","Level_3"), each=10) Response <- c(11, 8, 10, 12, 8, 12, 9, 9, 4, 12, 12, 9, 12, 10, 18, 24, 17, 16, 20, 11, 14, 7, 18, 8, 12, 10, 9, 14, 12, 10) Data Question_3<-data.frame(Treatment, Response) View(Data_Question 3) aggregate (Data Question_3$Response, list (Data Question_3$Treatment), mean) aggregate (Data_Question_3$Response, list (Data Question_3$Treatment), sd) aggregate (Response Treatment, Data Question 3, function…

Recently, management at Oak Tree Golf Course received a few complaints about the condition of the greens. Several players complained that the greens are too fast. Rather than react to the comments of just a few, the Golf Association conducted a survey of 100 male and 100 female golfers. The survey results are summarized here. Excel File: data02-31.xlsx Male Golfers Green Condition Gender Too Fast Male Handicap Under 15 15 or more 25 25 a. Complete the crosstabulation shown below. Green Condition Female Too Fast 10 Fine Fine 40 Female Golfers Total Green Condition Handicap Under 15 15 or more Too Fast 1 Fine 9 39 51 Total Which group shows the highest percentage saying that the greens are too fast? - Select your answer - b. Refer to the initial crosstabulations. For those players with low handicaps (better players), which group (male or female) shows the highest percentage saying the greens are too fast? For the low handicappers, the - Select your answer - have a higher percentage who…

Vince had 10 weeks to get in shape for a race. The line graph shows how many miles he ran per training session each week. 10-Week Training 7 6. 4 2 0 1 2 3 4 5 6 7 8 9 10 Week © 2020 StrongMind. Created using GeoGebra. What is the total number of miles that Vince ran per session in weeks 5, 6, 7, and 8? Enter your answer as a whole number, like this: 42 Miles

Describe the three primary charts and graphs used to organize and display data.

Recently, management at Oak Tree Golf Course received a few complaints about the condition of the greens. Several players complained that the greens are too fast. Rather than react to the comments of just a few, the Golf Association conducted a survey of 100 male and 100 female golfers. The survey results are summarized here. Excel File: data02-31.xlsx Male Golfers Male Green Condition Handicap Under 15 15 or more 25 25 a. Complete the crosstabulation shown below. Green Condition Gender Too Fast Fine Female 35 40 Too Fast 10 65 60 Fine 40 Total 100 100 Female Golfers 200 Green Condition Handicap Under 15 15 or more Too Fast 1 Note: This exercise is an example of Simpson's Paradox. 39 Fine 9 Total 75 125 Which group shows the highest percentage saying that the greens are too fast? Females, at 40% b. Refer to the initial crosstabulations. For those players with low handicaps (better players), which group (male or female) shows the highest percentage saying the greens are too fast? For…

complete screenshot please

Hi. Attached is the table for reference and the questions are right below. Please answer subparts #4-6. Thank you.

The basketball coach at a local college believes that his team scores more points at home games when more people show up. Below is a list of all home games last year with scores and corresponding attendance. Use Excel, SPSS, or work by hand to show your work finding r. Show your work on the attached pages. Score Attendance   Score Attendance 54 380   67 410 57 350   78 215 59 320   67 113 80 478   56 250 82 451   85 450 75 250   101 489 73 489   99 472 53 451       a. What is the correlation between Score and Attendance rounded to 2 decimals? b. In terms of strength and direction, how would you describe this correlation?  c. What is the obtained t-score for this correlation?  d. What is the critical t-score for a two-tailed test with a ?  e. Is this correlation significant based on the t-scores? f. Based on Table 10.4, approximately how many cases would you expect to need to…

The basketball coach at a local college believes that his team scores more points at home games when more people show up. Below is a list of all home games last year with scores and corresponding attendance. Use Excel, SPSS, or work by hand to show your work finding r. Show your work on the attached pages. Score Attendance   Score Attendance 54 380   67 410 57 350   78 215 59 320   67 113 80 478   56 250 82 451   85 450 75 250   101 489 73 489   99 472 53 451       What is the obtained t-score for this correlation? What is the critical t-score for a two-tailed test with a = 0.05? Is this correlation significant based on the t-scores?

The basketball coach at a local college believes that his team scores more points at home games when more people show up. Below is a list of all home games last year with scores and corresponding attendance. Use Excel, SPSS, or work by hand to show your work finding r. Show your work on the attached pages. Score Attendance   Score Attendance 54 380   67 410 57 350   78 215 59 320   67 113 80 478   56 250 82 451   85 450 75 250   101 489 73 489   99 472 53 451         g. What is the coefficient of determination for this relationship? h. Interpret for these two variables presuming a causal relationship was expected.

easure.

For each of the worksheets, Total Profit per Region and Sales per Month, decide which type of chart would best represent the data. Please be sure to discuss why you would choose these types of charts based on the data you would be visualizing.

please assist where the blank areas are on the table.   Are there differences in airfare depending on which travel agency website you utilize? The following data were collected on travel agency websites on July , . The following table contains the prices in U.S. dollars for a one-way ticket between the cities listed on the left for each of the three travel agency websites. Here the pairs of cities are the blocks and the treatments are the different websites. data below in table:     Websites           Flight From ‒ To Expedia ($)   TripAdvisor ($)   Priceline ($)   Atlanta to Seattle 176.00   166.00   175.80   New York to Los Angeles 195.00   195.00   206.20   Cleveland to Orlando 77.00   72.00   76.21   Dallas to Indianapolis 149.00   149.00   148.20   Use to test for any significant differences in the mean price of a one-way airline ticket for the three travel agency websites. If your…

I need help to do the exercises of the chart given for doing Excel and provide the steps as that need to follow the instructions.

Please help write answer on the computer

Make graphs for each section (a,b,c,d, and e).

The r code for side by side boxplot of vitamind v newage and vitamin d v country. Scatterplot code for relationship between vitamin d level and age.

None

(Please do not give solution in image format thanku)

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.   Based on the X-bar and R Charts that you developed for the 1st 10 days of data, is the process in control?   Group of answer choices No. The X-bar and R Charts are both out of control. No. The X-bar Chart is in control, but the R Chart is out of control. No. The R Chart is in control, but the X-bar Chart is out of control. Yes. The X-bar and R Charts are both in control.

You need to prepare for your meeting with the BeeSwaks executives by writing and graphing functions so thatyou can compare the volumes and resulting production costs of each candle. The BeeSwaks executives want tosee detailed support for the calculations done by their production staff, so you should come armed with labeledgraphs and worked-out equations to support them. 1) Use your equations from Lesson 1 for the Brick candle and the Egyptian candle to create a graph of twopolynomial functions so that you can compare volumes for different values of x. Compare the volumes. ( my equations, figured out in Lesson 1 below) Brick candle equation- V= x^3-x^2 Eqyptian candle equation- V= 7x^2   2) Use the graph from Question 1 to identify where the volumes are equal. Confirm this value by writing andsolving an equation that describes the difference between the volumes of the candle types. 3) . The same wax will be used to make each candle, and it costs 3/4 of 1¢ per cubic centimeter. Write…

I need assistance with parts a, b, and c.  Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrollment (in thousands) for Jefferson Community College for the nine most recent years. Click on the datafile logo to reference the data. Year Period (t) Enrollment(1,000s) 2001 1 6.5 2002 2 8.1 2003 3 8.4 2004 4 10.2 2005 5 12.5 2006 6 13.3 2007 7 13.7 2008 8 17.2 2009 9 18.1 A. Choose the correct time series plot. What type of pattern exists in the data? Positive trend pattern or negative trend pattern B. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, b0 = Slope, b1 =   MSE=    C. What is the forecast for year 10? Do not round your interim computations and round your final answer to two decimal places.

GUstevo Lir-Word Froblen Doom-uice Wld Unrel blems Link Sheet D O at Tools Add-ons Help Accessibility Last edit was 37 minutes ago mal text BIUA Arial 11 Use the graph below to complete the remaining boxes. Complete the table of values Cost of Reggie's graduation picnic $10 Attendees (x) Cost (y) $9 $7 4 $6 $5 $4 8 $3 10 $2 $1 1 2 456 10 Ay Find the Rate of Change: Attendees Ax Rise Run Find the Rate of Change: Answer each question: Answer each question: A. Write the Equation in (y = mx + b) A)Use vour eguation How much would it acer % & 4 6 7 8 Cost 3.

Pls help  might need to use excel

Could you please illustate a diagram to accompany your description? Thank you so much.