Question: Using MS Excel, create a new workbook with the following (Save as w7_firstname_lastname.xlsx). As an administrator, you recorded the requests from different locations (i.e. a

Using MS Excel, create a new workbook with the following (Save as w7_firstname_lastname.xlsx). As an administrator, you recorded the requests from different locations (i.e. a few states are listed) in the sheet below, you may create your own sheet. You need to explain the collected data. In the table below, you have the requests against the locations.

Software Installation requests ,Software Update requests ,Hardware Installation requests

WV 23 12 15

MD 13 8 5

VA 17 4 6

DC 14 6 2

NY 7 4 1

FL 29 21 11

You can use any data gathering for your choice Create at least 5 statistical functions and graph relating to the data. From the data discuss the trend (your conclusion, what does this data mean for your planning), You can use the question of "What if... then" https://support.office.com/en-us/article/Introduction-to-What-If-Analysis-22bffa5f-e891-4acc-bf7a-e4645c446fb4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using MS Excel, create a new workbook with the following ( Save as w 7 _ firstname _ lastname.xlsx or w 7 _ firstname _ lastname.xls ) . As an administrator, you recorded the requests from different...

Assignment Instructions Using MS Excel, create a new workbook with the following (Save as w7_firstname_lastname.xlsx or w7_firstname_lastname.xls). As an administrator, you recorded the requests from...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Objective This Course Project gives you the opportunity to practice by planning a project, from the onset with a project charter to an established project schedule and related artifacts. This Course...

Willowbrook Case Study question: Design the monthly billing statement for a family using a printer spacing chart or graph paper. Include a mock-up report and a report analysis form for each report ....

CIS 620/B Project Plan For the Global Collaboration Enterprise Information System 1200 12th Avenue, Suite 1200 Seattle, Washington 98114 U.S.A. November 11, 2015 Draft Version 19.0 November 11, 2015...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

The terms debit and credit are often used in describing the effects of transactions on different accounts. What do these terms mean?

Data for Weber Manufacturing are given in BE16-1. Supporting records show that (a) The Assembly Department used $24,000 of raw materials and $35,000 of the factory labor, and (b) The Finishing...

answer this Multiple Choice Question An increase in EPS is an indicator of O lower financial leverage O lower return on equity O lower profitability O higher profitability Need help? Review these...

a. 11. According to class discussion, which of the following is NOT another name for YTM? Required Rate of Retum b. Current Coupon Rate c. Discount Rate d. Current Market Rate O A a. B. b. O C. c. O...

List and explain the seven standard parts of a letter. (Objective 1)

What formatting guidelines should be followed if a letter is too long to fit onto one page? (Objective 1)

Ethics.Teamwork. In a group of three to five students, research on the Internet how blogs and instant messaging are being used in business. As a class, discuss your findings. (Objective 4)