I’m working on a data analytics question and need an explanation to help me learn. You just purchased a food truck and have begun selling in a large college town. As you are learning the market, you have been changing location every few days to get a sen

I’m working on a data analytics question and need an explanation to help me learn.

You
just purchased a food truck and have begun selling in a large college
town. As you are learning the market, you have been changing location
every few days to get a sense of local demand. In doing so, you’ve
decided to collect some data. In particular, you collect data on your
revenues and the distance of the truck location from the center of the
local university. The hope is to get a sense as to whether demand
notably varies depending on your proximity to the university.

undefined

Based on the data, please answer the following.

undefined

• What were the best days of the month for sales? (Top 5)
• What days of week are the best for sales?
• What was the total sales for the month?
• What days were the worst for sale? (Lowest 5)
• Rank
  the weeks by best sales from greatest to least: 1, 2, 3, or 4. Hint:
  total the week’s sales and group accordingly. Omit the 29-31 in your
  ranking.
• What is the average for the month?
• What is the mode?
• What is the range in sales?
• Run a regression and use the data to create a graph in Excel.
• Write a 500-word summary explaining to your manager how you can increase sales for the next month.

data in the attachment is related to question