Scribd
Upload
12 views23 pages

FDS Assignment

The document presents a sales dataset containing order details such as Order ID, Customer Name, Product, Category, Quantity, Unit Price, Total Price, Tax, Discount, Region, and Order Date. It includes calculations for total sales, taxes, and discounts, as well as regression statistics and residual outputs for analyzing the impact of discounts on sales. The dataset is organized in various formats, including sorting by total price and alphabetical order.

Uploaded by

mvanusha86
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
12 views23 pages

FDS Assignment

The document presents a sales dataset containing order details such as Order ID, Customer Name, Product, Category, Quantity, Unit Price, Total Price, Tax, Discount, Region, and Order Date. It includes calculations for total sales, taxes, and discounts, as well as regression statistics and residual outputs for analyzing the impact of discounts on sales. The dataset is organized in various formats, including sorting by total price and alphabetical order.

Uploaded by

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

Sales Dataset

Order ID Customer Name Product Category Quantity Unit Price ($)


1001 John Smith Wireless MoElectronics 2 25.99
1002 Emily Davis Bluetooth S Electronics 1 59.99
1003 Michael Brown Notebook Office 5 3.49
1004 Sarah Wilson Desk Lamp Furniture 1 34.5
1005 David Lee Keyboard Electronics 3 45
1006 Lisa Johnson Coffee Mug Kitchen 4 8.99
1007 Robert Taylor Monitor Sta Furniture 2 22.75
1008 Jessica White USB Cable Electronics 10 4.99
1009 Daniel Harris Sticky NotesOffice 6 1.99
1010 Olivia Clark Water BottleKitchen 2 12.5
ataset
Discount (%) Region Order Date
5% East 5-Jan-23
10% West 10-Jan-23
0% North 15-Jan-23
15% South 20-Jan-23
8% East 25-Jan-23
0% West 30-Jan-23
12% North 5-Feb-23
5% South 5-Mar-23
0% East 9-Jan
10% West 8-Jan-23
Sales Dataset
Order ID Customer Name Product Category
1001 John Smith Wireless Mouse Electronics
1002 Emily Davis Bluetooth Speaker Electronics
1003 Michael Brown Notebook Office
1004 Sarah Wilson Desk Lamp Furniture
1005 David Lee Keyboard Electronics
1006 Lisa Johnson Coffee Mug Kitchen
1007 Robert Taylor Monitor Stand Furniture
1008 Jessica White USB Cable Electronics
1009 Daniel Harris Sticky Notes Office
1010 Olivia Clark Water Bottle Kitchen

Column1 Multiplication Addition Subtraction


Order ID Total Sales Total Sales+ Tax Total Sales - Discount
1001 51.98 54.579 51.30426
1002 59.99 62.9895 56.69055
1003 17.45 18.3225 18.3225
1004 34.5 36.225 30.79125
1005 135 141.75 130.41
1006 35.96 37.758 37.758
1007 45.5 47.775 44.9085
1008 49.9 52.395 46.1076
1009 11.94 12.537 12.537
1010 25 26.25 23.625
Sales Dataset
Quantity Unit Price ($) Tax Discount (%) Region
2 25.99 5% 6% East
1 59.99 5% 10% West
5 3.49 5% 0% North
1 34.5 5% 15% South
3 45 5% 8% East
4 8.99 5% 0% West
2 22.75 5% 12% North
10 4.99 5% 5% South
6 1.99 5% 0% East
2 12.5 5% 10% West

Divison
Single Unit Price
25.65213
56.69055
3.6645
30.79125
43.47
9.4395
22.45425
4.61076
2.0895
11.8125
Order Date
5-Jan-23
10-Jan-23
15-Jan-23
20-Jan-23
25-Jan-23
30-Jan-23
5-Feb-23
5-Mar-23
9-Jan
8-Jan-23
Sales Dataset
Order ID Customer Name Product Category Quantity
1001 John Smith Wireless Mouse Electronics 2
1002 Emily Davis Bluetooth Speaker Electronics 1
1003 Michael Brown Notebook Office 5
1004 Sarah Wilson Desk Lamp Furniture 1
1005 David Lee Keyboard Electronics 3
1006 Lisa Johnson Coffee Mug Kitchen 4
1007 Robert Taylor Monitor Stand Furniture 2
1008 Jessica White USB Cable Electronics 10
1009 Daniel Harris Sticky Notes Office 6
1010 Olivia Clark Water Bottle Kitchen 2

Sorting based on Total Pric


Order ID Customer Name Product Category Quantity
1005 David Lee Keyboard Electronics 3
1002 Emily Davis Bluetooth Speaker Electronics 1
1001 John Smith Wireless Mouse Electronics 2
1008 Jessica White USB Cable Electronics 10
1007 Robert Taylor Monitor Stand Furniture 2
1006 Lisa Johnson Coffee Mug Kitchen 4
1004 Sarah Wilson Desk Lamp Furniture 1
1010 Olivia Clark Water Bottle Kitchen 2
1003 Michael Brown Notebook Office 5
1009 Daniel Harris Sticky Notes Office 6

Sorting based on Alphabetical


Order ID Customer Name Product Category Quantity
1009 Daniel Harris Sticky Notes Office 6
1005 David Lee Keyboard Electronics 3
1002 Emily Davis Bluetooth Speaker Electronics 1
1008 Jessica White USB Cable Electronics 10
1001 John Smith Wireless Mouse Electronics 2
1006 Lisa Johnson Coffee Mug Kitchen 4
1003 Michael Brown Notebook Office 5
1010 Olivia Clark Water Bottle Kitchen 2
1007 Robert Taylor Monitor Stand Furniture 2
1004 Sarah Wilson Desk Lamp Furniture 1
Sales Dataset
Unit Price ($) Total Price Tax Discount ( Region Order Date
25.99 51.30426 5% 6% East 5-Jan-23
59.99 56.69055 5% 10% West 10-Jan-23
3.49 18.3225 5% 0% North 15-Jan-23
34.5 30.79125 5% 15% South 20-Jan-23
45 130.41 5% 8% East 25-Jan-23
8.99 37.758 5% 0% West 30-Jan-23
22.75 44.9085 5% 12% North 5-Feb-23
4.99 46.1076 5% 5% South 5-Mar-23
1.99 12.537 5% 0% East 9-Jan
12.5 23.625 5% 10% West 8-Jan-23

ng based on Total Price


Unit Price ($) Total Price Tax Discount ( Region Order Date
45 130.41 5% 8% East 25-Jan-23
59.99 56.69055 5% 10% West 10-Jan-23
25.99 51.30426 5% 6% East 5-Jan-23
4.99 46.1076 5% 5% South 5-Mar-23
22.75 44.9085 5% 12% North 5-Feb-23
8.99 37.758 5% 0% West 30-Jan-23
34.5 30.79125 5% 15% South 20-Jan-23
12.5 23.625 5% 10% West 8-Jan-23
3.49 18.3225 5% 0% North 15-Jan-23
1.99 12.537 5% 0% East 9-Jan

based on Alphabetical order


Unit Price ($) Total Price Tax Discount ( Region Order Date
1.99 12.537 5% 0% East 9-Jan
45 130.41 5% 8% East 25-Jan-23
59.99 56.69055 5% 10% West 10-Jan-23
4.99 46.1076 5% 5% South 5-Mar-23
25.99 51.30426 5% 6% East 5-Jan-23
8.99 37.758 5% 0% West 30-Jan-23
3.49 18.3225 5% 0% North 15-Jan-23
12.5 23.625 5% 10% West 8-Jan-23
22.75 44.9085 5% 12% North 5-Feb-23
34.5 30.79125 5% 15% South 20-Jan-23
Sales Dataset
Order ID Customer Product Category Quantity Unit Price (Total Price Tax
1001 John SmithWireless MElectronics 2 25.99 51.30426 5%
1002 Emily Davi Bluetooth Electronics 1 59.99 56.69055 5%
1003 Michael Br Notebook Office 5 3.49 18.3225 5%
1004 Sarah Wils Desk LampFurniture 1 34.5 30.79125 5%
1005 David Lee Keyboard Electronics 3 45 130.41 5%
1006 Lisa JohnsoCoffee MugKitchen 4 8.99 37.758 5%
1007 Robert TaylMonitor St Furniture 2 22.75 44.9085 5%
1008 Jessica WhiUSB Cable Electronics 10 4.99 46.1076 5%
1009 Daniel HarrSticky NoteOffice 6 1.99 12.537 5%
1010 Olivia Clar Water BottKitchen 2 12.5 23.625 5%

Filtering
Order ID Customer Product Category Quantity Unit Price (Total Price Tax
1001 John SmithWireless MElectronics 2 25.99 51.30426 5%
1002 Emily Davi Bluetooth Electronics 1 59.99 56.69055 5%
1005 David Lee Keyboard Electronics 3 45 130.41 5%
1008 Jessica WhiUSB Cable Electronics 10 4.99 46.1076 5%
Discount ( Region Order Date
6% East 5-Jan-23
10% West 10-Jan-23
0% North 15-Jan-23
15% South 20-Jan-23
8% East 25-Jan-23
0% West 30-Jan-23
12% North 5-Feb-23
5% South 5-Mar-23
0% East 9-Jan
10% West 8-Jan-23

Discount ( Region Order Date


6% East 5-Jan-23
10% West 10-Jan-23
8% East 25-Jan-23
5% South 5-Mar-23
Sales Dataset
Order ID Customer Product Category Quantity Unit Price (Total Price Tax
1001 John SmithWireless MElectronics 2 25.99 51.30426 5%
1002 Emily Davi Bluetooth Electronics 1 59.99 56.69055 5%
1003 Michael Br Notebook Office 5 3.49 18.3225 5%
1004 Sarah Wils Desk LampFurniture 1 34.5 30.79125 5%
Discount ( Region Order Date
6% East 5-Jan-23
10% West 10-Jan-23
0% North 15-Jan-23
15% South 20-Jan-23
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.598129
R Square 0.357758
Adjusted R 0.277478
Standard E 2.377336
Observatio 10

ANOVA
df SS MS F Significance F
Regression 1 25.18618 25.18618 4.456369 0.067767
Residual 8 45.21382 5.651727
Total 9 70.4

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%
Lower 95.0%
Intercept 5.621113 1.217299 4.617695 0.001715 2.814018 8.428209 2.814018
Discount ( -31.09405 14.72946 -2.111011 0.067767 -65.06024 2.872139 -65.06024

RESIDUAL OUTPUT

Observation
Predicted Quantity
Residuals
1 4.066411 -2.066411
2 2.511708 -1.511708
3 5.621113 -0.621113
4 0.957006 0.042994
5 3.133589 -0.133589
6 5.621113 -1.621113
7 1.889827 0.110173
8 4.066411 5.933589
9 5.621113 0.378887
10 2.511708 -0.511708
Discount (%) Residual Plot
10
Residuals

Upper 95.0% 5
8.428209 0
2.872139 0 2 4 6 8 10 12
-5
Discount (%)
l Plot

10 12
Sales Dataset
Order ID Customer Product Category Quantity Unit Price (Total Price Tax
1001 John SmithWireless MElectronics 2 25.99 51.30426 5%
1002 Emily Davi Bluetooth Electronics 1 59.99 56.69055 5%
1003 Michael Br Notebook Office 5 3.49 18.3225 5%
1004 Sarah Wils Desk LampFurniture 1 34.5 30.79125 5%
1005 David Lee Keyboard Electronics 3 45 130.41 5%
1006 Lisa JohnsoCoffee MugKitchen 4 8.99 37.758 5%
1007 Robert TaylMonitor St Furniture 2 22.75 44.9085 5%
1008 Jessica WhiUSB Cable Electronics 10 4.99 46.1076 5%
1009 Daniel HarrSticky NoteOffice 6 1.99 12.537 5%
1010 Olivia Clar Water BottKitchen 2 12.5 23.625 5%
Discount ( Region Order Date
6% East 5-Jan-23
10% West 10-Jan-23
0% North 15-Jan-23
15% South 20-Jan-23
8% East 25-Jan-23
0% West 30-Jan-23
12% North 5-Feb-23
5% South 5-Mar-23
0% East 9-Jan
10% West 8-Jan-23
Sales Dataset
Order ID Customer NameProduct Category Quantity Unit Price (Total Price
1001 John Smith Wireless MousElectronics 2 25.99 51.30426
1002 Emily Davis Bluetooth SpeElectronics 1 59.99 56.69055
1003 Michael Brown Notebook Office 5 3.49 18.3225
1004 Sarah Wilson Desk Lamp Furniture 1 34.5 30.79125
1005 David Lee Keyboard Electronics 3 45 130.41
1006 Lisa Johnson Coffee Mug Kitchen 4 8.99 37.758
1007 Robert Taylor Monitor Stand Furniture 2 22.75 44.9085
1008 Jessica White USB Cable Electronics 10 4.99 46.1076
1009 Daniel Harris Sticky Notes Office 6 1.99 12.537
1010 Olivia Clark Water Bottle Kitchen 2 12.5 23.625

Chart Title
Quantity 6%
12

10

0
1 2 3 4 5 6 7 8 9 10

Chart Title
25.99 59.99 Unit Price ($) Column F
Quantity 1 2 Column E
Discount (%) 6% Column I
1
100 2

50
8 3
0

7 4

6 5
Tax Discount ( Region Order Date
5% 6% East 5-Jan-23
5% 10% West 10-Jan-23
5% 0% North 15-Jan-23
5% 15% South 20-Jan-23
5% 8% East 25-Jan-23
5%
5%
0% West
12% North
30-Jan-23
5-Feb-23
C hart Ti
5% 5% South 5-Mar-23 Quantity Discou
5% 0% East 9-Jan
5% 10% West 8-Jan-23 10
9
8
7
6
5
4
3
2
1
0 2 4 6

Chart Title
12
10
10

0
1 2 3 4 5 6 7 8

Quantity Unit Price ($)

Chart Title
70
60
50
40
30
Chart Title
70
60
50
40
30
20
10
0
0 2 4 6 8 10 12

Quantity 2 1
Column E Unit Price ($) Column F
C hart Title
Quantity Discount (%)

4 6 8 10 12

hart Title
70

60

50

40

30

20

10

0
5 6 7 8 9 10

ty Unit Price ($)


10 12

You might also like