# Attachment # 00006777 - Applied_Analytics.docx

Applied_Analytics.docx (16.1 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)

# Question

Offered Price \$30.00

# Applied Analytics

Question # 00089280
Subject: Statistics
Due on: 08/07/2015
Posted On: 08/05/2015 01:48 PM

Rating:
4.1/5
Posted By
Questions:
5
Tutorials:
0
Feedback Score:

Question

­­­­­­­­­­­­­­­___________________________________________________

 The distance between any two US cities (excluding cities in Alaska and Hawaii) can be approximated by this formula: 69 * ? (lat1 - lat2)2 + (long1 - long2)2 The Citydata.xlsx file contains the latitude and longitude of selected US cities. Create a table that gives the distance between any two of the listed cities. The Quarterlygnpdata.xlsx workbook contains quarterly GNP data for the United States (in billions of 1996 dollars). Extract this data to three columns so that the first column contains the year, the second column contains the quarter number, and the third column contains the GNP The Textstylesdata.xlsx file contains information about the style, color, and size of a variety of shirts. For example, the first shirt is style 100 (indicated by digits between the colon and the hyphen). Its color is 65, and its size is L. Use text functions to extract the style, color, and size of each shirt.

How many workdays (including holidays) are there between July 10, 2005, and August 15, 2006?

 A project begins on December 4, 2005. The project consists of Activities 1, 2, and 3. Activity 2 can start the day after Activity 1 finishes. Activity 3 can start the day after Activity 2 finishes. Set up a worksheet that accepts as inputs the duration (in days) of the three activities and outputs both the month and year during which each activity is completed.
Attachments

# Tutorials for this Question

Available for
\$39.00

#### Applied Analytics

Tutorial # 00083684
Posted On: 08/05/2015 01:56 PM
Posted By:
neil2103
Questions:
9341
Tutorials:
13656
Feedback Score:
Tutorial Preview …data xxxxxxxxxx and xxxxxx be done xxxxxxx data Q4) xxxx solution xx xxxxxxxx No xxxx needed Q5) xxxx…
Attachments
Applied_Analytics.xlsx (10.16 KB)
Preview: can xx placed xxxx cells C17,C18,C19 xxx One example xx as xxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx between x and B xxx be calculated xxxx the xxxxxxx xx below=SQRT((C24-C25)^2+(D24-D25)^2)Q3) xxxxxxxxxx can be xxxx only with xxxxxxx Number xx xxxxxxx days xxxxxxx july 10,.....
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable