Data Analysis Response
Provide (2) 200 words response with a minimum of 1 APA references for RESPONSES 1 AND 2 below. Response provided should further discuss the subject or provide more insight. To further understand the response, below is the discussion post that’s discusses the responses. 100% original work and not plagiarized. Must meet deadline.
RESPONSE 1:
A spreadsheet (also referred to as a Microsoft Excel worksheet) is “a two-dimensional grid with columns and rows,” this arrangement of columns and rows when filled with data is referred to as a “table” and the entirety of the “page”—including the table—is referred to generally as a “spreadsheet” (Excel made easy, n.d.).
Professionals and lay-people may use spreadsheets as data storage and analysis tools—data can be digitally recorded, comparative formulas applied, and analysis completed based on the information contained in a well-formatted spreadsheet. Information may be highlighted, emphasized, or displayed using graphs or charts in order to effectively present the results of data analysis in professional settings such as executive stakeholder meetings, professional journal publications, or analytical research reports. Spreadsheets can provide a clear and effective format for storing and conveying information, which makes professional communication and appropriate record-keeping much more efficient.
Spreadsheets may be used to manage daily administrative tasks such as creating professional work schedules, planning maintenance activities, creating schedules for equipment availability, proposing professional training timelines, tracking departmental budgetary outlay, etc. A particularly useful example of administrative tasks which are made more efficient by the use of spreadsheets is network and infrastructure documentation. Information technology administrators can use spreadsheets to track the pertinent details of their equipment (name, location, IP address, MAC address, software information, patch information, etc.) for the purposes of asset management, change management, or troubleshooting. The utility of spreadsheets can be increased by applying formulas to particular columns or rows in order to cause Excel (or one’s spreadsheet application of choice) to perform desired calculations automatically—for example, give an average, sum up the number of a certain kind of asset, etc.
Best regards,
Ashley
References
Excel made easy: A beginner’s guide. (n.d.). Retrieved from
https://www.keynotesupport.com/excel-basics/excel-for-beginners-guide.shtml
RESPONSE 2:
This week we are focused on using Excel, along with utilizing all the different functions available within it. Excel is a tool that is commonly used to make spreadsheets, but what is a spreadsheet? In Excel, “a spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data. Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions” (PerfectXL, n.d., para. 1).
Spreadsheets can be utilized in a variety of different ways. For example, financial departments can use spreadsheets to depict payroll and accounting information for employees. They can also use spreadsheets to compare the revenue the company makes each month in order to figure out trends; they can then use the spreadsheet to create visual aids, like graphs, for easy representation of the information/data. Families can also use spreadsheets to figure out financial plans and compare the cost of living in different cities if they are planning on moving soon. For example, when my husband and I were looking at possibly moving to another state, we used the Excel spreadsheet to compare the cost of living and other expenses. Because of the data we gathered, we realized we couldn’t move at this time, mostly due to the cost of childcare in other states.
At my work, I actually use spreadsheets every day. I am the training manager at my unit, so I am responsible for keeping track of everyone’s training dates. I use a spreadsheet in order to keep track of who accomplished what and on what day, and then I use the different functions in excel to tell me when someone is coming due for something within 30 days. I have the spreadsheets highlight the upcoming due dates in yellow. I also use spreadsheets to keep track of everyone’s weekly, monthly, and yearly flying numbers. This helps me inform the pilots if they are going to meet their weekly, monthly, and yearly flying quotas or not.
I hope everyone has a great week!
v/r
Taylor
References:
PerfectXL. (n.d.). What is a Spreadsheet? Retrieved on 14 December 2020 from https://www.perfectxl.com/excel-glossary/what-is-a-spreadsheet/