Scribd
Upload
28 views1 page

Questions Bakery Data

The assignment involves analyzing sales data from La Petit Bakery, which sells various baked goods and beverages. Students are required to create a new column for the day of the week and assess how sales are influenced by factors such as the day of the week, month, sales trends, and promotions. The data for this analysis is provided in the BakeryData.xlsx and LaPetitBakery.xlsx files, covering the years 2013-2015.

Uploaded by

sohamchatterjee25
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
28 views1 page

Questions Bakery Data

The assignment involves analyzing sales data from La Petit Bakery, which sells various baked goods and beverages. Students are required to create a new column for the day of the week and assess how sales are influenced by factors such as the day of the week, month, sales trends, and promotions. The data for this analysis is provided in the BakeryData.xlsx and LaPetitBakery.xlsx files, covering the years 2013-2015.

Uploaded by

sohamchatterjee25
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Class Assignment 3

La Petit Bakery sells cakes, pies, cookies, coffee, and smoothies. The owner has hired you to analyze
factors affecting sales of these products.

The file BakeryData.xlsx contains the data for this example and the file LaPetitBakery.xlsx contains
all the completed PivotTables. In the Bakerydata.xlsx workbook you can see the underlying daily
sales data recorded for the years 2013–2015.

Considering that the week starts from Monday, please answer the questions given below for the
“Bakerydata” dataset.

1. Based on the weekday for each date, create a column “daywk” which will contain the day of
the week (E.g., Monday, Tuesday, etc.).
2. Using the functions that you have learnt, find out how La Petit Bakery’s sales are affected by
the following:
a. Day of the week
b. Month of the year
c. An upward (or downward!) trend over time in sales
d. Promotions such as price cuts

You might also like