Assignment: Revenue, Sales, Regression
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.
Based on the data, please answer the following.
a. What were the best days of the month for sales? (Top 5)
b. What days of week are the best for sales?
c. What was the total sales for the month?
d. What days were the worst for sale? (Lowest 5)
e. 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.
f. What is the average for the month?
g. What is the mode?
h. What is the range in sales?
i. Run a regression and use the data to create a graph in Excel.
j. Write a 500-word summary explaining to your manager how you can increase sales for the next month.
Format your assignment according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.