{"id":2148,"date":"2023-02-18T02:04:43","date_gmt":"2023-02-18T02:04:43","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/excel-question\/"},"modified":"2023-02-18T02:04:43","modified_gmt":"2023-02-18T02:04:43","slug":"excel-question","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/excel-question\/","title":{"rendered":"Excel Question"},"content":{"rendered":"
\n Learning Goal: <\/b>I’m working on a excel exercise and need an explanation and answer to help me learn.<\/p>\n

Data Analytics Center demand forecast:<\/span> Having an optimal staffing model in place for your Data Analytics team is a great step but without an understanding of what kind of demand for services you might encounter creates an environment of great uncertainty. Luckily you have 24 months of data that represents historical requests for projects and data reporting services. Health system leadership expects an ongoing increase in demand for analytics and reporting<\/span>
services. The increase in demand that precipitated that need to track the number of requests is the exact thing that prompted leadership to request the creation of a Data Analytics Center.<\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n

For this assignment you will use your experience with forecasting methods to:<\/span><\/p>\n

    \n
  1. Select an appropriate forecasting method for the Data Analytics Center (hint: there is seasonal variation in the data)<\/span><\/span><\/li>\n
  2. Perform a forecasting exercise to project future demand<\/span> (over the next 12 months) using a linear regression model (hint: you need to run regression in MS-Excel)<\/span><\/span><\/span><\/li>\n
  3. Analyze the summary measures and evaluate the forecast (recommend action steps)<\/span><\/span><\/li>\n<\/ol>\n

    <\/a><\/span><\/span><\/p>\n

    Data Analytics Forecasting information:<\/span><\/p>\n