Perform T-Tests: Perform t-tests on identified binary (dichotomous) variables to determine differences between data groups. Perform a t-test to investigate customers' orders based on time of day. Group the orders according to those placed in the morning and those placed after noon. Differentiate between the two groups of orders in terms of: The average number of orders (or volume) The average total amount Perform a t-test by creating a new variable to group the restaurants based on whether or not they are categorized as "Pizza Place." Determine if there is a difference in the volume and the average order amount between restaurants categorized as Pizza Place and those that are not. Interpret Statistical Results: Determine the statistical significance of your t-test results using the p values generated. Determine whether there's a statistically significant difference at the p

Overview You are a business analyst for an organization that distributes pizza ingredients to various restaurants. These ingredients include dough, sauces, and toppings. Your organization wants to expand its customer base but does not know what kind of restaurant or which US. region to target. You have been given a Clean Customer Sales Data Set that is a representative sample of the sales at your customers' restaurants for 2015 and 2016. This also contains household income data for the restaurant zip codes. Your organization's leadership is concerned about rising delivery costs and is considering whether they should specically target pizzerias as customers. They are also considering whether they should only offer morning deliveries. Currently. the organization's roster of customers includes a wide range of restaurants. many of which are open for business before noon. You have been asked to analyze your customer data set and provide insight and recommendations. First, you must determine differences in the orders placed at different times of the day and compare orders placed in pizzerias with those in other restaurants. You will then need to analyze these differences to determine whether these differences are due to chance or are statistically signicant and determine how these may impact your recommendations. For this activity, you will use MS Excel to perform t-tests on the given data set to determine whether the differences that you see between two groups are signicant or due to chance