This is the second part of the question.Please provide the excel formula, the correct EXCEL FORMULA. FileHomeInsertDrawFormulasDataReviewViewHelpØ Editing vCalibriBv A$v 囲、ラ、國...General0000A1fx Accessibility tab summary: Given information for this question is presented in rows 2 through 17. Requirement information is presented in rows 20 through 32.A.BEFGHM1.A marketing research company tests the effectiveness of three new flavorings for a new sauce using a sample of 30 people, divided randomly into three groups of 10 people each.3.Group 1 tastes Flavor 1, Group 2 tastes Flavor 2, and Group 3 tastes Flavor 3.4.Each person is then given a questionnaire that evaluates how enjoyable the beverage was.5.The scores are shown below. Determine whether there is a perceived significant difference between the three flavorings.6.Flavor 1Flavor 2Flavor 31312917819101961511111614122012101514161318101814918111541416121111161718 A1fx Accessibility tab summary: Given information for this question is presented in rows 2 through 17. Requirement information is pBEF1819 Required:20 Complete the ANOVA tables below:21GroupsCountSumMeanVarianceSS22Flavor 123Flavor 224 Flavor 32526 ANOVAAlpha0.05SSdfMSP valueF crit27Sources28 Between Groups29 within Groups30 Total31alpha,do not rejectthe null hypothesis.32 Since p-value is33343536 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work.37 Nothing in this area will be graded, but it will be submitted with your assignment.38A Graded WorksheetII

B F rch company tests the effectiveness of three new flavorings for a new sauce using a sar vor 1, Group 2 tastes Flavor 2, and Group 3 tastes Flavor 3. n given a questionnaire that evaluates how enjoyable the beverage was. wn below. Determine whether there is a perceived significant difference between the Elavor 2 Flavor 3

B F rch company tests the effectiveness of three new flavorings for a new sauce using a sar vor 1, Group 2 tastes Flavor 2, and Group 3 tastes Flavor 3. n given a questionnaire that evaluates how enjoyable the beverage was. wn below. Determine whether there is a perceived significant difference between the Elavor 2 Flavor 3

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section: Chapter Questions

Problem 8SGR

See similar textbooks

Similar questions

According to the 2017 Corporate Travel Index compiled by Business Travel News, the average daily cost for business travel in the United States rose to $321 per day (Executive Travel website). The file Travel contains sample data for an analogous study on the estimated daily living costs for an executive traveling to various international cities. The estimates include a single room at a four-star hotel, beverages, breakfast, taxi fares, and incidental costs. City Daily LivingCost ($) City 1 242.87 City 2 260.93 City 3 194.19 City 4 260.76 City 5 355.36 City 6 346.32 City 7 165.37 City 8 250.08 City 9 326.76 City 10 283.56 City Daily LivingCost ($) City 11 213.00 City 12 284.08 City 13 139.16 City 14 436.72 City 15 240.87 City 16 310.41 City 17 223.73 City 18 181.25 City 19 238.10 City 20 250.61 (a)Compute the sample mean (in dollars). (Round your answer to the nearest cent.) $______ (b)Compute the sample standard deviation…
The Consumer Reports Restaurant Customer Satisfaction Survey is based upon 148,599 visits to full-service restaurant chains (Consumer Reports website). One of the variables in the study is meal price, the average amount paid per person for dinner and drinks, minus the tip. Suppose the reporter for the Sun Coast Times thought that it would be of interest to her readers to conduct a similar study for restaurants located on the Grand Strand section in Myrtle Beach, South Carolina. The reporter selected a sample of 8 seafood restaurants, 8 Italian restaurants, and 8 steakhouses. The following data show the meal prices ($) obtained for the 24 restaurants sampled. Use a = .05 to test whether there is a significant difference among the mean meal price for the three types of restaurants. Italian Seafood Steakhouse $12 $16 $24 13 18 19 15 17 23 17 26 25 18 23 21 20 15 22 17 19 27 24 18 31
The Consumer Reports Restaurant Customer Satisfaction Survey is based upon 148,599 visits to full-service restaurant chains (Consumer Reports website). One of the variables in the study is meal price, the average amount paid per person for dinner and drinks, minus the tip. Suppose a reporter for the Sun Coast Times thought that it would be of interest to her readers to conduct a similar study for restaurants located on the Grand Strand section in Myrtle Beach, South Carolina. The reporter selected a sample of 8 seafood restaurants, 8 Italian restaurants, and 8 steakhouses. The following data show the meal prices ($) obtained for the 24 restaurants sampled. Use a = 0.05 to test whether there is a significant difference among the mean meal price for the three types of restaurants. Please answer the questions in the image.
Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The company maintains a large sales force who call on existing customers and look for new business. The national sales manager is investigating the relationship between the number of sales calls made and the miles driven by the sales representative. Also, do the sales representatives who drive the most miles and make the most calls necessarily earn the most in sales commissions? To investigate, the vice president of sales selected a sample of 25 sales representatives and determined: The amount earned in commissions last month (y) The number of miles driven last month (x1) The number of sales calls made last month (x2) The information is reported below. Commissions ($000) Calls Driven Commissions ($000) Calls Driven 22 143 2,375 38 150 3,291 13 132 2,228 45 145 3,103 33 148 2,735 29 147 2,122 39 146 3,354 38 146 2,795 24 142 2,291 38 153 3,213 48 142 3,449…
Cincinnati Paint Company sells quality brands of paints through hardware stores throughout the United States. The company maintains a large sales force who call on existing customers and look for new business. The national sales manager is investigating the relationship between the number of sales calls made and the miles driven by the sales representative. Also, do the sales representatives who drive the most miles and make the most calls necessarily earn the most in sales commissions? To investigate, the vice president of sales selected a sample of 25 sales representatives and determined: The amount earned in commissions last month (y) The number of miles driven last month (x1) The number of sales calls made last month (x2) The information is reported below. Commissions ($000) Calls Driven Commissions ($000) Calls Driven 23 68 2,372 39 188 3,291 14 30 2,229 44 218 3,103 34 136 2,733 29 105 2,123 39 180 3,353 38 162 2,794 24 77 2,291 37 154 3,209 47 186 3,451 15 25…
As part of a study designed to compare hybrid and similarly equipped conventional vehicles, a group tested a variety of classes of hybrid and all-gas model cars and sport utility vehicles (SUVs). Suppose the following data show the miles-per-gallon rating obtained for two hybrid small cars, two hybrid midsize cars, two hybrid small SUVs, and two hybrid midsize SUVs; also shown are the miles per gallon obtained for eight similarly equipped conventional models. Class Type MPG Small Car Hybrid 37 Small Car Conventional 28 Small Car Hybrid 44 Small Car Conventional 32 Midsize Car Hybrid 27 Midsize Car Conventional 23 Midsize Car Hybrid 32 Midsize Car Conventional 25 Small SUV Hybrid 27 Small SUV Conventional 21 Small SUV Hybrid 28 Small SUV Conventional 22 Midsize SUV Hybrid 23 Midsize SUV Conventional 19 Midsize SUV Hybrid 24 Midsize SUV Conventional 18 At the ? = 0.05 level of significance, test for significant effects due to class, type, and…
Use the data from Fuentes’ study to test the hypothesis that the proportion of grocery stores that currently carries Fuentes’ Candied Bacon Potato Chips is equal across its eight U.S. sales regions. Use a 5 .05. New England Mid-Atlantic Midwest Great Plains South Atlantic Deep South Mountain Pacific Yes Yes No No Yes Yes Yes No No Yes Yes Yes Yes Yes Yes No Yes Yes No Yes No Yes No No Yes No Yes Yes Yes Yes Yes No Yes Yes No Yes Yes Yes No Yes No No No Yes No Yes No No Yes Yes Yes Yes Yes Yes Yes No No Yes Yes No Yes No Yes Yes Yes No No No Yes Yes Yes Yes Yes No No Yes Yes Yes No No Yes Yes Yes Yes Yes Yes No Yes Yes No No Yes Yes No Yes No No Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes No Yes No No Yes Yes No No No Yes No Yes Yes Yes Yes Yes No No Yes Yes Yes Yes No Yes No Yes No Yes Yes Yes Yes No Yes No Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes No…
A survey of 800 college seniors resulted in the following crosstabulation (Table 1) regarding their undergraduate major and whether or not they plan to go to graduate school. Please use the information to answer questions 3-6. Undergraduate Major Graduate School Business Engineering Others Total Yes 70 84 126 280 No 182 208 130 520 Total 252 292 256 800 Among the students who plan to go to graduate school, what percentage indicated "Other" majors?
Hillary and Adams, Inc., is a privately owned firm located in Atlanta that serves as the regional distributor of natu-ral food products for Georgia, Kentucky, North Carolina, South Carolina, and Tennessee. They are particularlywell known for their unique blend of fiery hot Habanera sauces. Every week, a truck leaves the large distributioncenter in Atlanta to stock local warehouses located in Charlotte, North Carolina; Charleston, South Carolina;Columbia, South Carolina; Knoxville, Tennessee; Lexington, Kentucky; and Raleigh, North Carolina. The truckvisits each local warehouse only once and returns to Atlanta after all the deliveries have been completed. Thedistance between any two cities in miles is given below John Jensen, vice president of logistics at Hillary and Adams, Inc., is worried about the rising fuel costs.With a reduction in operating budgets, he is interested in finding a route that would minimize the distance trav-eled by the truck.Use the NN heuristic to identify a…
The human papillomavirus associated with the development of cervical cancer, genital warts, and some less common cancers. John Hopkins conducted a study to investigate the characteristics of female patients who came to their clinics between 2006 and 2008 to begin the three-shot regimen of vaccinations with the anti-human papillomavirus (HPV) medication Gardasil. A contingency table summarizing the vaccine completions by race for 1222 patients is provided below. 1.State the null and alternative hypotheses. 2.Compute the test statistic. Compute the test statistic. Document how the expected counts and the value of the test statistic are computed and enter them into the table and input box provided. Round the expected counts to 3 decimal places and the test statistic to 2 decimal places. 3.Compute the p-value. Provide the name of the distribution and the parameters used to compute the p-value. Then enter your anwer rounded to 4 decimal places. 4.Interpret the results of the significance…
If all the HRDs who completed the survey from the energy industry had their head office in Asia, how many more people is this than we would expect, from what we know about the geographical location of Head offices more generally? 4, 17, 21, 43, or 47?
You work for an insurance company and are studying the relationship between types of crashes and the vehicles involved. As part of your study, you randomly select 3632 vehicle crashes and organize the resulting data as shown in the contigency table. At α=0.01, can you conclude that the type of crash depends on the type of vehicle? Complete parts (a) through (d). Vehicle Type of crash Car Pickup Sport utility Single-vehicle 876 393 342 Multiple-vehicle 1143 475 403 Question content area bottom Part 1 (a) Identify the claim and state the null and alternative hypotheses. H0: The type of crash and the type of vehicle are . Ha: The type of crash and the type of vehicle are . (a) Identify the claim and state the null and alternative hypotheses. H0: The type of crash and the type of vehicle are Ha: The type of crash and the type of vehicle are . The alternative hypothesis is the claim. Part 2 (b) Determine the degrees of…