# Attachment # 00006777 - Applied_Analytics.docx

Applied_Analytics.docx (16.1 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
You are thinking of advertising Microsoft products on a sports telecast. As you buy more ads, the price of each ad decreases as shown in the following table:Number of adsPrice per ad1-5\$12,0006-10\$11,00011-20\$10,00021 and higher\$9,000For example, if you buy 8 ads, you pay \$11,000 per ad, but if you buy 14 ads, you pay \$10,000 per ad. Write a formula that yields the total cost of purchasing any number of ads.___________________________________________________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)2The 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 GNPThe 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.

# 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:
7
Tutorials:
0
Feedback Score:

Question

 Complete in Microsoft Excel and use Excel Functions to solve You are thinking of advertising Microsoft products on a sports telecast. As you buy more ads, the price of each ad decreases as shown in the following table: Number of ads Price per ad 1-5 \$12,000 6-10 \$11,000 11-20 \$10,000 21 and higher \$9,000 For example, if you buy 8 ads, you pay \$11,000 per ad, but if you buy 14 ads, you pay \$10,000 per ad. Write a formula that yields the total cost of purchasing any number of ads.

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

 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:
9587
Tutorials:
14214
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