+1(978)310-4246 credencewriters@gmail.com
  

Course name: ENTD261
Week 7: Data Analysis
Instructions
Using MS Excel, create a new workbook with the following (Save as
w7_fougnigue_soro.xlsx or w7_fougnigue_soro.xls).
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
Hardware
Software Update
Installation
Installation
requests
requests
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 graphs 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”
Introduction to What-if Analysis
Submit your week 7 work in w7_fougnigue_soro.xlsx
or w7_firstname_lastname.xls
Please refer to the attached sample solution file,
w7_first_lastName.xlsx, for help. In place of first and lastName in
the file name make sure your first and last names are present.
Requirements
Points
Data Layout
20
Statistical functions and graph
50
Data Analysis Conclusion
30
TOTAL POINTS
100
Stretch Assignment: (I’d like to include this portion of the assignment in
future classes. I ask that you give it a try and provide me a short summary
on your thoughts of adding this to the class going forward!)
Macros are little recorded sessions of code changes in Excel. We know
scripting as anything trigger or event based that is recurrent. I ask that
you create a script in Excel by creating a Macro. Your macro should ZERO
OUT all of the data in the table you are using. You can call the macro,
StartOfTheDay. You would run this macro, say, when you arrived in the
morning to enter new data into the tables and purge the data from the
previous day. Give it a try! Remember save your file as a filename.xlsm (if
it includes a macro). If you’d prefer a different macro, just let me know
the pupose of your macro in the comments section of your submission.
Record a Macro in Excel
Attachments
w7_graphs example.PNG
(107.14 KB)
w7_summary example.PNG
(81.66 KB)
w7_first_lastName.xlsx
(46.69 KB)

Purchase answer to see full
attachment

  
error: Content is protected !!