Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello can you help me with these 6 questions Use the data to complete the questions fIn Excel, create a table of descriptive statistics using

Hello can you help me with these 6 questions Use the data to complete the questions

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
\fIn Excel, create a table of descriptive statistics using the Data> > Data Analysis> >Descriptive Statistics function. EXCEL ASSISTINTen D Uala W/ NO Label Data Review View Automate Acrobat Tell me Comments Share III 21 72 Y Clear GE H EO . Group Analysis Tools Reapply 2 Ungroup Stocks Currencies Z J Sort Filter Text to go What-If Data Analysis Advanced Columns Analysis Subtotal 2 Solver Data Analysis Q als2 Residuals3 Analysis Tools OK Covariance Cance Descriptive Statistics Exponential Smoothing F-Test Two-Sample for Variances Fourier Analysis Histogram Input the descriptive statistics requested into the table; make sure you round to two decimal places, except for the n/N, which can be whole numbers. Also, make sure that if the number is a decimal, such as .02, you input a 0 before the decimal, 0.02 due to APA standards for these statistics. Then, answer the questions below. Just for your information, these tables are not in APA style due to Canvas constraints. n M SD Skew Kurtosis Papa John's Pizza Hut Mozzi's What is the total sample size? N =Regarding the descriptives table that you created in the previous question, answer the questions below. . Which pizza place had the highest average rating according to the data we have? [ Select ] . Looking at the descriptive statistics in the Excel table, look for the statistic that represents the rating that appears most often in each of the groups. Which pizza place has the highest number? [ Select ] . Which pizza place had the highest amount of variation in the ratings? [ Select ] . Which pizza place had the largest sample size? [ Select ] . Did the skewness of all three pizza places fall within the normal range? [ Select ] . Did the kurtosis of all three pizza places fall within the normal range? [ Select ]Homogeneity of Variance You may find the Video Walkthrough Ex helpful with the remaining questions. Run Levene's test to check for homogeneity of variance. Fill in the tables below with the proper statistics. Round to two decimal places. Just for your information, these tables are not in APA style due to Canvas constraints. Average Variance Residuals 1 (Papa John's) Residuals2 (Pizza Hut) Residuals3 (Mozzi's) In the table below, round to two decintal places except for df; df should be in whole numbers. For the p-value, do not put a O in front of the decimal due to APA guidelines. Round the p-value to two decimal places. Source of df F p F critical Variation Between Groups Within GroupsAfter running Levene's test to check for homogeneity of variance, did you find that the assumption was violated or met? The p-value was statistically significant, the assumption was violated. The p-value was not statistically significant, the assumption was violated. O The p-value was statistically significant, the assumption was met. The p-value was not statistically significant, the assumption was met.Fill in the table with the proper statistics. Round to two decimal places accordingly. Make sure to put a 0 before any decimals with an absolute value

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Prealgebra

Authors: Elayn Martin Gay

7th edition

321955048, 978-0321955043

More Books

Students also viewed these Mathematics questions

Question

=+3 What are useful marketing metrics?

Answered: 1 week ago

Question

\f

Answered: 1 week ago