Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AirTraffic - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Cut Times New Roman
AirTraffic - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Cut Times New Roman - 12 A A ce Wrap Text General Be Copy Paste B I A E Merge & Center * % .00 Format Painter 00 3.0 Clipboard Font Alignment Number A1 X V fx Controller A B C D E F G H H J K 1 Controller | System A System B System C 2 1 15 15 18 3 2 14 14 14 4 3 10 11 15 4 13 12 17 6 5 16 13 16 7 6 13 13 13OzoneLevels - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do X Cut Times New Roman - 12 A A ce Wrap Text Custom Paste Copy B IU W Format Painter A Merge & Center v % 100 Clipboard Font Alignment Number A1 X V fx Date A B C D E F G H I J 1 Date Birmingham Memphis Little Rock Jackson 2 January 9 18 20 18 14 3 January 17 23 31 22 30 4 January 18 19 25 22 21 5 January 31 29 36 28 35 6 February 1 27 31 28 24 7 February 6 26 31 31 25 8 February 14 31 24 19 25 9 February 17 31 31 28 28 10 February 20 33 35 35 34 11 February 29 20 42 42 21Medical2 - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do do Cut Times New Roman * 12 A A al Wrap Text General Paste Em Copy B = Merge & Center v % " .00 Format Painter IU YY Av Clipboard Font Alignment Number A1 X Y Florida A B C D E F G H J Florida New York North Carolina 13 14 10 A W N 12 9 12 17 15 15 5 17 12 18 6 20 16 12 21 24 14 8 16 18 17 14 14 8 10 13 15 14 11 17 17 16 12 12 20 18 13 9 11 17 14 12 23 19 15 15 19 15 16 16 17 13 17 15 14 14 18 13 9 11 19 10 14 12 20 11 13 13 21 17 11 11 22Excel Assignment 3 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are provided in previous assignment) 1. An Economist was interested in testing if there is a difference in the average deals processed by the 3 adopted systems (see file: Air Traffic). Three random samples were taken, one from each system; systems A, B, and C. a. report the descriptive statistics for each sample b. report and analyze the ANOVA test for the 3 systems. 2. An Economist was interested in testing if the average temperature degrees have changed due to the Ozone problem in 4 cities: Birmingham, Memphis, Little Rock, and Jackson (see file: Ozone levels). Four random samples were taken, one from each city. a. report the descriptive statistics for each sample b. report and analyze the ANOVA test for the 4 cities. 3. An Economist was interested in comparing the average number of infections between three states: Florida, New York, North Carolina (see file: Medical2). Compute: a. report the descriptive statistics for each sample b. report and analyze the ANOVA test for the 3 states
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started