Task 2 ANOVA Single factor analysis using excel ONLY (2 5 pts) Data source ANOVA Excel (given) The data contain three sales categories' weekly revenue ( Delivery, Onsite, and take out), the manager wants to know if there is a significant difference between the sales category and if there is which of the three sales has a higher revenue Create case specific hypothesis based on the given information Compute your work using Excel Based on your results give a conclusion and write 1 3 sentences to describe your findings Provide clear excel step by step Delivery Onsite Take out 4200 6900 3500 5300 5400 4000 4900 5800 5300 5300 6400 4200 4300 6400 5000 4400 5500 3900 4500 5600 5500 5200 5400 3900 5400 5800 4000 5300 6400 4000 4900 6400 5300 5300 5400 4200 4300 5800 5000 4400 6400 3900 4900 6400 4000 5300 5500 5300 4300 5600 4200 4400 5400 5000 4500 5800 3900 5200 4900 5500 5400 5300 3900 5300 4300 4000 4900 4400 4000 4200 4500 5300 5000 5200 4200 3900 5400 6400 5500 5300 6400 3900 5400 5500 4000 5800 5600 4000 4900 5400 5300 5800 4200 6400 5000 6400

The Answer is in the image, click to view ...

Question: Task 2: ANOVA Single factor analysis using excel ONLY (2.5 pts) Data source: ANOVA Excel (given) The data contain three sales categories' weekly revenue (

Task 2: ANOVA Single factor analysis using excel ONLY (2.5 pts)

Data source: ANOVA Excel (given)

The data contain three sales categories' weekly revenue ( Delivery, Onsite, and take-out), the manager wants to know if there is a significant difference between the sales category and if there is which of the three sales has a higher revenue.

Create case specific hypothesis based on the given information.
Compute your work using Excel
Based on your results give a conclusion and write 1-3 sentences to describe your findings.

Provide clear excel step-by-step

Delivery	Onsite	Take-out
4200	6900	3500
5300	5400	4000
4900	5800	5300
5300	6400	4200
4300	6400	5000
4400	5500	3900
4500	5600	5500
5200	5400	3900
5400	5800	4000
5300	6400	4000
4900	6400	5300
5300	5400	4200
4300	5800	5000
4400	6400	3900
4900	6400	4000
5300	5500	5300
4300	5600	4200
4400	5400	5000
4500	5800	3900
5200	4900	5500
5400	5300	3900
5300	4300	4000
4900	4400	4000
4200	4500	5300
5000	5200	4200
3900	5400	6400
5500	5300	6400
3900	5400	5500
4000	5800	5600
4000	4900	5400
5300		5800
4200		6400
5000		6400

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

ANOVA Single factor analysis using excel ONLY Data source: ANOVA Excel The data contain three sales categories' weekly revenue ( Delivery, Onsite, and take-out), the manager wants to know if there is...

ID Salary Compa- Midpoint ratio Age Performance Service Gender Rating Raise Degree Gender Grade 1 Copy Employee Data set to this page. The ongoing question that the weekly assignments will focus on...

Set Week Three During this week, we will look at ways of testing multiple (more than two) data samples at the same time. We will continue to use the data and assignment file that we opened in Week 2,...

PLEASE: DO NOT OPEN TAB(s) ON YOUR BROWSER OTHE DO NOT SEND THE SOLUTION FILE TO YOUR EM DO NOT OPEN ANY COURSE MATERIAL . SAVE YOUR FILE AS: CIS623_FinalExam_YourName Refresh your browser before...

Need help with excel (Instructions are given) also please share the links!! 1. Two-Sample t-Test Two-Sample t-Test using the Data Analysis Toolpak in Excel This document includes instructions to...

I can not for the life of me figure out what I'm doing wrong with Tukey HSD. I provided the Q table I have been given at the bottom as well. Here I need help with 4-b 8 Exercise 13-41 Static 3.33...

This case study will utilize Excel fileReal_Estate.xlsx, which consists of 100 homes purchased in 2018.It includes variables regarding the number of bedrooms, number of bathrooms, whether the house...

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 65.1 27 36.1 61.4 46.6 73.3 39.7 23.2 74.6 22.8 23.4 62 40.7 23 24 51.1...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

What does a variable overhead efficiency variance tell management?

Two charges of identical mass m, one with charge q, the other 4q, hang from strings of length I from a common point. Assume q is sufficiently small so that any angle you're looking for is very small,...

The two main forecasting lechniques based on a belief in the value of added infomation are fundamertal analysis and A . inetficient analysis. B . efficient analysis. C . technical analysis. D ....

in tables 1 and 2, please determine the [thiol1] and [thiol2] used. Buffer: 0.15M phosphate, 2 mM EDTA stock thiol solutions (5 mM in Buffer): DTT, HCys, L-Cys, L-GSH Table 1. Thiol #1: Sample Volume...

12. Evaluate the following statement. We shouldnt generalize from what people do in the ultimatum game because $10 is a trivial amount of money. When larger amounts of money are on the line, people...

13. last word What do you think of the ethics of using unconscious nudges to alter peoples behavior? Before you answer, consider the following argument made by economists Richard Thaler and Cass...

4. Theres no such thing as bad publicity. Evaluate this statement in terms of the recognition heuristic. LO8.2