Qso 560 Module 5-1data Shortcomingssouthern New Hampshire Un

QSO 560 Module 5-1Data ShortcomingsSouthern New Hampshire UniversityDate: Subject: Importance of Capturing Additional Variables for Data AnalysisTo: IT DepartmentFrom: Dorcia Heath, Business AnalystImpact of Existing Variables:The following chart displays the average total for each restaurant category.The following chart illustrates the average expenditure per order type and restaurant category.Delivery:Breaking down the data by restaurant category greatly impacts the analysis of average order sizes. This method allows the organization to evaluate the performance of various restaurant types and their effectiveness across different order types. Through this analysis, the organization can identify which restaurant categories perform well and their success across various order types. As a result, this analysis provides the organization with the essential information neededto strategically increase its distribution of pizza ingredients by pinpointing the most suitable restaurant types for partnerships.Impact of a New Variable:The following chart illustrates the average total order value across the four U.S. regions.The chart below shows the average monetary value of an order in each region, broken down by order type.The chart shows the average dollar value of an order for each restaurant category within each region.The data analysis reveals clear regional disparities in order volume and restaurant category distribution. The Northeast and