This Will Be Ran Through Turnitininstructionsusing Ms Excel Create 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 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 231215, MD 1385, VA 1746, DC 1462, NY 741, FL 292111. 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_firstname_lastname.xlsx or w7_firstname_lastname.xls.
Paper For Above instruction The assignment requires the development of an Excel workbook that captures and analyzes data related to various requests for software installation, software updates, and hardware installations across different states. The primary goal is to organize the data efficiently, perform meaningful statistical analyses, visualize the data through graphs, and interpret the trends to inform planning decisions, incorporating elements of "What-if" analysis for forecasting scenarios. To begin, the data must be neatly laid out within an Excel spreadsheet, with clear labels for each category: location, and number of requests for software installation, updates, and hardware installation. The provided data indicates request counts for selected states, including West Virginia (WV), Maryland (MD), Virginia (VA), District of Columbia (DC), New York (NY), and Florida (FL). For analytical flexibility, students may generate additional data as needed, simulating real-world request data to enrich their analysis. Once the data is organized, creating at least five statistical functions is essential. These could include measures such as the average number of requests per location, median, mode, maximum, and minimum values for different request types. These functions will provide insights into the central tendencies and variances within the request data. Using Excel's built-in functions like AVERAGE, MEDIAN, MODE, MAX, and MIN simplifies this process. In addition to statistical calculations, visual representation of the data with graphs enhances interpretability. Bar charts and pie charts are suitable for illustrating request distributions across states and request types. For example, a bar chart could compare total requests per state, while a pie chart could show