Warning: call_user_func_array() expects parameter 1 to be a valid callback, function 'wpdocs_custom_excerpt_length' not found or invalid function name in /home/myonysqo/myonlinehomeworkhelper.com/wp-includes/class-wp-hook.php on line 287

Data Analysis

October 31, 2015 0 Comment

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




21 and higher

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 complete

  • 100% Original Essays Guaranteed
  • 8 Hrs Delivery Available
  • Original and creative work
  • Timely delivery guaranteed
  • 100% confidentiality guarantee
  • Variety of disciplines, topics, and deadlines
  • Discounts offered on every custom-ordered paper
  • Original papers written from scratch;
  • 100% confidential;
  • 100% plagiarism-free;
  • Fast turn-around time;
  • Direct communication with the writer;
  • Instant email delivery;
  • Free plagiarism reports;
  • 24/7 customer support team.
  • Choose your font
  • 12 point font size
  • Double-sized
  • Over 275 words/page
  • Text aligned left
  • One inch margin

We Accept


you have a money back guarantee if you are not satisfied with our services