top of page
• StudentGuiders

# ANLY 500 Homework-3

4.4. The Excel file Atlanta Airline Data provides arrival and taxi-in time statistics for one day at Atlanta Hartsfield International airport. Find the average and standard deviation of the difference between the scheduled and actual arrival times and the taxi-in time to the gate. Compute the zscores for each of these variables

ANLY 500 Homework-3
.docx

Answer: Average (Difference between scheduled and actual arrival time) is 4.91 Average (Taxi-in time) is 11.6 Standard Deviation (Difference between scheduled and actual arrival time) is 54.81 Standard Deviation(Taxi-in time) is 5.48 Z-scores: Z-score Difference Z-Taxi-in 0.18409050.437956-0.1990513-1.0219-0.2537858-0.10949-0.1990513-0.474450.0016420.255474-0.4909688-1.02190.14760080.0729930.2753147-0.10949-0.1260719-0.29197-0.1625616-0.47445-0.2537858-0.83942-0.12607191.1678830.18409050.255474-0.2537858-0.65693-0.3997446-0.10949-0.107827-0.839420.3300493-0.83942-0.32676522.0802920.3665390.0729930.129356 1.715328 -0.4544791 -0.47445 -0.3267652 -0.83942 And so on 4.22. The Excel file Cell Phone Survey reports opinions of a sample of consumers regarding the signal strength, value for the dollar, and customer service for their cell phone carriers. Use PivotTables to find the following: 1 the average signal strength by type of carrier 2 average value for the dollar by type of carrier and usage level 3 variance of perception of customer service by carrier and gender Answer: 1. the average signal strength by type of carrier: AT&T – 3.46 Sprint- 2.8 T-mobile – 3 Verizon – 3.8 Others – 2.67 Row LabelsAverage of Signal strengthAT&T3.4Other2.666666667Sprint2.8T-mobile3Verizon3.8(blank)5Grand Total 3.3076923082. average value for the dollar by type of carrier and usage level By Type of carrier and Usage Level Average of Value for the DollarColumn LabelsRow LabelsAverageHig hLo wVery highGrand TotalAT&T3.542.533.2Other2.833333333433Sprint4.66666666754.8T-mobile444Verizon2.666666667343.5(blank)44Grand Total3.39130434843.23.45454545 53.42307692 3 3. variance of perception of customer service by carrier and gender Var of Customer ServiceColumn LabelsRow LabelsFMGrand TotalAT&T0.6964285711.0955882350.973333333Other00.9523809520.777777778Sprint00.3333333330.2T-mobile#DIV/0!#DIV/0!0.5Verizon0.81.31.333333333(blank)#DIV/0!#DIV/0!Grand Total0.7614379080.9705882350.926093514Verizon has highest signal strength, and sprint has the lowest signal strength but valued highly by customers. Verizon has high variance and Sprint has low variance 4.31. The Excel file Auto Survey contains a sample of data about vehicles owned, whether they were purchased new or used, and other types of data. Use the Descriptive Statistics tool to summarize the numerical data, find the correlations among each of the numerical variables, and construct PivotTables to find the average miles/gallon for each type of vehicle, and also the average miles/gallon and average age for each type of new and used vehicle. Summarize the observations that you can make from these results. Answer:

## Recent Posts

See All

The community health nurse is providing information to a COPD support group. The nurse shares information about the Air Quality Index (AQI) and encourages clients to review the information and plan th

When infusing pantoprazole, use a separate IV line, a pump, and an in-line filter. A brown wrapper and frequent vital signs are not needed. A client has gastroesophageal reflux disease (GERD). The pro

What is an example of a biological health risk? a. pesticides b. bacteria contaminated dirnking water c. loud machinery d. garden fertilizer b. bacteria contaminated drinking water Which would a

bottom of page