AutoSaveAssignment 3 - ExcelO Search困ffEmerson Oakes EOFileHomeInsertPage LayoutFormulasDataReviewViewHelpA ShareP CommentsN12feABEFGHJKLMNPтYAAABACAssignment 32 Problem #334The National Restaurant Association randomly selected 20 restaurants in a major metropolitan area and asked patrons to tell them about their experience.5Each score below represents the percentage of respondends who rated a restaurant as either "excellent" or "very good" on several criteria including6"Quality of Entrée", "Atmosphere", and "Quality/Speed of Service". An overall score was also used to ran the restuarants evaluated. The data is as follows:RestaurantOverallEntrée Quality AtmosphereService194.494.690.997.8293.096.784.296.710392.9100.0100.088.51191.388.694.897.112590.595.187.991.213690.392.582.198.814790.296.086.392.01589.992.692.688.916989.494.785.990.8171089.290.683.390.5181189.290.982.088.6191289.193.193.189.7Plot Area201388.792.678.391.3211487.293.191.773.6221587.291.075.089.7231686.694.478.191.6241786.295.577.490.9251886.194.976.591.5261986.192.172.389.3272085.293.577.491.928A. Determine the estimated regression equation that can be used to predict the overall score given the scores for Entrée Quality, Atmosphere, andQuality/Speed of Service. What is the R score for that regression equation ?B. Use the Ftest to determne the overall significance of the relationship. What is your conclusion at a 0.05 level of confidence ?C. Use the t-test to determine the significance of each independent variable. What is your conclusion at the 0.05 level of significance?D. Remove any independent variable that is not significant from your estimated regression equation. What is your recommended estimated regressionequation? What is the R value for that equation?29X303132333435O 4)3637388:33 PM39402/27/202141Problem 1Problem 2Problem 3Problem 4Problem 5+Ready囲目+60%

Name: AutoSaveAssignment 3 - ExcelO Search困ffEmerson Oakes EOFileHomeInsert
Uploaded: 2024-03-20T07:07:12.000Z
Channel: Bartleby
Description: AutoSaveAssignment 3 - ExcelO Search困ffEmerson Oakes EOFileHomeInsertPage LayoutFormulasDataReviewViewHelpA ShareP CommentsN12feABEFGHJKLMNPтYAAABACAssignment 32 Problem #334The National Restaurant Association randomly selected 20 restaurants in a m

Note: Hi there! Thank you for posting the question. As your question has more than 3 parts, we have…

Math

Statistics

The National Restaurant Association randomly selected 20 restaurants in a major metropolitan area and asked patrons to tell them about their experience. Each score below represents the percentage of respondends who rated a restaurant as either "excellent" or "very good" on several criteria including "Quality of Entrée", "Atmosphere", and "Quality/Speed of Service". An overall score was also used to ran the restuarants evaluated. The data is as follows: Restaurant Overall Entrée Quality Atmosphere Service 1 94.4 94.6 90.9 97.8 2 93.0 96.7 84.2 96.7 92.9 100.0 100.0 88.5

The National Restaurant Association randomly selected 20 restaurants in a major metropolitan area and asked patrons to tell them about their experience. Each score below represents the percentage of respondends who rated a restaurant as either "excellent" or "very good" on several criteria including "Quality of Entrée", "Atmosphere", and "Quality/Speed of Service". An overall score was also used to ran the restuarants evaluated. The data is as follows: Restaurant Overall Entrée Quality Atmosphere Service 1 94.4 94.6 90.9 97.8 2 93.0 96.7 84.2 96.7 92.9 100.0 100.0 88.5

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: i) Test the claim of u> 2015 and use c=.90. Provide a sketch of the Critical Value. Evaluate the…

A: Sample data set = 40 , 33 , 77 , 12 , 23 , 56 , 23 , 19 , 29 ( inminutes)…

Q: You are a high school student council member tasked with analyzing how much time students in your…

A: ### Given DataThe data representing the number of hours 16 students spent on extracurricular…

Q: It is estimated that 70% of households own a riding lawnmower. A sample of 22 households is studied.…

Q: b. The test statistic (t |(please show your answer to 3 decimal places.) c. The p-value = (Please…

A: b. The test statistic value is obtained by using EXCEL. The software procedure is given below:…

Q: Please answer the questions in the photo and explain. Thank you

A: (a) Sample Mean = (2.2 +0.5 +2.4 +2.7 +2 +1.5 +0.2 +1.5 +0.1 +0.2)/10 = 1.33 (b) Here, we're…

Q: Use the Plan, Solve and Conclude steps in answering this question

Q: The Computer Anxiety Rating Scale (CARS) measures an individual’s level of computer anxiety, on a…

A: Male : Sample mean(M1) = 40.26 Standard deviation(S1) = 13.35 Female : Sample mean (M2) = 36.85…

Q: Find the mean of the data set: 14, 19, 13, 22, 7

A: Given data is : 14, 19, 13, 22, 7 Number of terms is n=5 To find the mean.

Q: The Condé Nast Traveler Gold List provides ratings for the top 20 small cruise ships. The data shown…

A: using excel data analysis tool for regression , steps are: write data>menu>data>data…

Q: Compute the coefficient of variation CVar .

A: Given that, 2(red), 4(black), 8(blue), 6(green), 10(orange), 12(black).

Q: If a child psychologist wanted to determine if there is a relationship between gender of a child and…

A: Chi-square test of independence should be used here.

Q: Maci is a social networking maniac! Although she prefers Instagram, she also spends a lot of time…

A: Introduction A variable is a no., characteristic which can be counted or measured.

Q: A class of 5 students averaged 70% on a given test. A class of 9 students averaged 80% on the same…

A: Introduction: Suppose there are k groups numbered 1, 2, 3, …, k – 1, and k.

Q: A researcher at the Sloan-Kettering Cancer Research Center was once criticized or falsifying data.…

Q: how many sports played male vs female based on the data

A: Given, The number of sports played by the students: Grade Number of students 9 16 10 13 11…

Q: (d) What is the nonresponse rate? (e) Suggest some methods that could be used in a future survey to…

A: The purpose of a survey is to examine the opinions, behaviors, or experiences of individuals or…

Q: Calculate the 75% percentiles, 25% percentiles, and the IQR for the following data: 9, 12, 20,…

A: Given : Observation 9 12 20 5 14 7 16 13

Q: A local store owner is interested in finding the mean age of her customers. She randomly surveys 82…

A: Key statistical concepts comprise of knowledge of population, sample, parameter, and statistic.

Q: Find the median and the mode of the set of data: 98.6, 102, 101, 98.6, 98.5, 98.6, 99.0, 98.6, 97.3,…

A: The solution is :

Q: Atlanta area animal shelters euthanize more animals per year than most other major city shelters.…

A: From the stem and plot, it is observed that data ranges 81100 to 90100. There is only one mode at…

Q: National Geographic Explorer 89.1 93.1 89.7 Silver Cloud 88.7 78.3 91.3 Celebrity Xpedition 87.2…

A: a) We use excel to estimate the regression equation that can predict the overall score given the…

Q: expensive). The toy was priced the same at all retail stores. Compute the percentage of variance…

Q: In marketing children’s products, it is extremely important to produce television commercials that…

A: Given: Toys/Games Food/Candy Children's Clothing 42 55 30 45 58 35 48 52 42 40 60 32 50…

Topic Video

Question

AutoSave
Assignment 3 - Excel
O Search
困
ff
Emerson Oakes EO
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
A Share
P Comments
N12
fe
A
B
E
F
G
H
J
K
L
M
N
P
т
Y
AA
AB
AC
Assignment 3
2 Problem #3
3
4
The National Restaurant Association randomly selected 20 restaurants in a major metropolitan area and asked patrons to tell them about their experience.
5
Each score below represents the percentage of respondends who rated a restaurant as either "excellent" or "very good" on several criteria including
6
"Quality of Entrée", "Atmosphere", and "Quality/Speed of Service". An overall score was also used to ran the restuarants evaluated. The data is as follows:
Restaurant
Overall
Entrée Quality Atmosphere
Service
1
94.4
94.6
90.9
97.8
2
93.0
96.7
84.2
96.7
10
3
92.9
100.0
100.0
88.5
11
91.3
88.6
94.8
97.1
12
5
90.5
95.1
87.9
91.2
13
6
90.3
92.5
82.1
98.8
14
7
90.2
96.0
86.3
92.0
15
89.9
92.6
92.6
88.9
16
9
89.4
94.7
85.9
90.8
17
10
89.2
90.6
83.3
90.5
18
11
89.2
90.9
82.0
88.6
19
12
89.1
93.1
93.1
89.7
Plot Area
20
13
88.7
92.6
78.3
91.3
21
14
87.2
93.1
91.7
73.6
22
15
87.2
91.0
75.0
89.7
23
16
86.6
94.4
78.1
91.6
24
17
86.2
95.5
77.4
90.9
25
18
86.1
94.9
76.5
91.5
26
19
86.1
92.1
72.3
89.3
27
20
85.2
93.5
77.4
91.9
28
A. Determine the estimated regression equation that can be used to predict the overall score given the scores for Entrée Quality, Atmosphere, and
Quality/Speed of Service. What is the R score for that regression equation ?
B. Use the Ftest to determne the overall significance of the relationship. What is your conclusion at a 0.05 level of confidence ?
C. Use the t-test to determine the significance of each independent variable. What is your conclusion at the 0.05 level of significance?
D. Remove any independent variable that is not significant from your estimated regression equation. What is your recommended estimated regression
equation? What is the R value for that equation?
29
X
30
31
32
33
34
35
O 4)
36
37
38
8:33 PM
39
40
2/27/2021
41
Problem 1
Problem 2
Problem 3
Problem 4
Problem 5
+
Ready
囲
目
+
60%

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step by step

Solved in 5 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Hypothesis Tests and Confidence Intervals for Means$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions

d) Create a 99% Confidence interval for the mean. Provide a sketch of the critical value and calculate the standard error. Only for this part use o = 23.8
Find the mean, median, and mode for the following scores: 8,7,5,7,0,10,2,4,11,7,8,7
The Computer Anxiety Rating Scale (CARS) measures an individual’s level of computer anxiety, on a scale from 20 (no anxiety) to 100 (highest level of anxiety). Researchers at a large university administered CARS to 80 business students. One of the objectives of the study was to determine whether there is a difference between the level of computer anxiety experienced by female students and male students. Of the 80 student survey takers, 40 were male, 40 were female. The results are in the table below for statistical analysis of variability between the two samples. All of these analyses are run with a 95% level of confidence. Males Females Sample Mean 40.26 36.85 Sample Standard Deviation 13.35 9.42 Perform the test chosen in part (d) of the previous problem and supply this information: a. What is the value of the test statistic? b. Find the probability of getting these results if there is no difference in anxiety ratings between the…
Here are ratings (on a scale from 1 through 5) for various Super Bowl party foods. You have to decide which food is rated highest (5 is a winner and 1 a loser). Decide what type of average you will use and why.
fill blanks underlines.
The Condé Nast Traveler Gold List provides ratings for the top 20 small cruise ships. The data shown below are the scores each ship received based upon the results from Condé Nast Traveler's Annual Readers' Choice Survey. Each score represents the percentage of respondents who rated a ship as excellent or very good on several criteria, including Shore Excursions and Food/Dining. An overall score was also reported and used to rank the ships. The highest ranked ship, the Seabourn Odyssey, has an overall score of 94.4, the highest component of which is 97.8 for Food/Dining. Shore Ship Overall Food/Dining Excursions Seabourn Odyssey 94.4 90.9 97.8 Seabourn Pride 93.0 84.2 96.7 National Geographic Endeavor 92.9 100.0 88.5 Seabourn Sojourn 91.3 94.8 97.1 Paul Gauguin 90.5 87.9 91.2 Seabourn Legend 90.3 82.1 98.8 Seabourn Spirit 90.2 86.3 92.0 Silver Explorer 89.9 92.6 88.9 Silver Spirit 89.4 85.9 90.8 Seven Seas Navigator 89.2 83.3 90.5 Silver Whisperer 89.2 82.0 88.6 National Geographic…
A store manager kept track of the number of newspapers sold each week over an 8-week period. The results were as follows: 0, 88, 71, 201, 113, 269, 248, 250. Find the 5 number summary for the data. Is the data discrete or continious?
A consumer group wanted to determine if there was a difference in customer perceptions about prices for a specific type of toy depending on where the toy was purchased. In the local area there are three main retailers: W-Mart, Tag, and URToy. For each retailer, the consumer group randomly selected 5 customers, and asked them to rate how expensive they thought the toy was on a 1-to-10 scale (1= not expensive, to 10 = very expensive). The toy was priced the same at all retail stores. 1. What kind of statistical test should be used to test the consumer group's research goal, assuming that the researcher wanted to use the 1-to-10 scale as a numerical interval measure? A. Repeated-measures t-test B. One-way Independent Measures ANOVA C. Repeated-measures ANOVA D. Independent-measures t-test 2. State the hypothesis that aims to test the consumer group’s research goal (i.e., what is H0 and HA).
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Television Newspaper Gross Revenue Advertising Advertising ($1,000s) ($1,000s) ($1,000s) 97 5.0 1.5 2.0 2.0 06 95 4.0 1.5 92 2.5 2.5 103 3.0 3.3 94 3.5 2.3 94 2.5 4.2 105 3.0 2.5 a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 1 decimal). Revenue = TVAdv b. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals). Revenue = TVAdv + NVAdv c. Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)? - Select your answer - Interpret the coefficient in each case. In - Select your answer - :, the coefficient is an estimate of the change in revenue due to a one-unit change in…
Find the percentage of scores of the following