Scribd
Upload
13 views21 pages

Statistical Analysis of Sales Data

The document contains statistical summaries of a dataset with 1000 entries, detailing various financial metrics such as costs, income, and unit prices. It includes measures of central tendency and dispersion, such as mean, standard deviation, and quartiles, for different variables. Additionally, it provides information about the structure of the dataset and confirms that there are no missing values in the data.

Uploaded by

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

Statistical Analysis of Sales Data

The document contains statistical summaries of a dataset with 1000 entries, detailing various financial metrics such as costs, income, and unit prices. It includes measures of central tendency and dispersion, such as mean, standard deviation, and quartiles, for different variables. Additionally, it provides information about the structure of the dataset and confirms that there are no missing values in the data.

Uploaded by

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

Ques on1

a)

c)

>ng)

d)

sort(Funding,decreasing = TRUE)
Ques on2

a)

Non-numerical variable(s) ignored: Invoice ID, Branch, City, Customer type, Gender, Product line,
Date, Time, PaymentDescrip ve Sta s cs

data

N: 1000

cogs gross income gross margin percentage Quan ty Ra ng Tax 5%

----------------- --------- -------------- ------------------------- ---------- --------- ---------

Mean 307.59 15.38 4.76 5.51 6.97 15.38

[Link] 234.18 11.71 0.00 2.92 1.72 11.71

Min 10.17 0.51 4.76 1.00 4.00 0.51

Q1 117.89 5.89 4.76 3.00 5.50 5.89

Median 241.76 12.09 4.76 5.00 7.00 12.09

Q3 449.21 22.46 4.76 8.00 8.50 22.46

Max 993.00 49.65 4.76 10.00 10.00 49.65

MAD 222.65 11.13 0.00 2.97 2.22 11.13

IQR 330.41 16.52 0.00 5.00 3.00 16.52

CV 0.76 0.76 0.00 0.53 0.25 0.76


Skewness 0.89 0.89 NaN 0.01 0.01 0.89

[Link] 0.08 0.08 0.08 0.08 0.08 0.08

Kurtosis -0.09 -0.09 NaN -1.22 -1.16 -0.09

[Link] 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00

N 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00

[Link] 100.00 100.00 100.00 100.00 100.00 100.00

Table: Table con nues below

Total Unit price

----------------- --------- ------------

Mean 322.97 55.67

[Link] 245.89 26.49

Min 10.68 10.08

Q1 123.79 32.85

Median 253.85 55.23

Q3 471.67 77.94

Max 1042.65 99.96

MAD 233.78 33.37

IQR 346.93 45.06

CV 0.76 0.48

Skewness 0.89 0.01

[Link] 0.08 0.08


Kurtosis -0.09 -1.22

[Link] 1000.00 1000.00

N 1000.00 1000.00

[Link] 100.00 100.00

>

> datastr=str(data)
spc_tbl_ [1,000 × 17] (S3: spec_tbl_df/tbl_df/tbl/[Link])
$ Invoice ID : chr [1:1000] "750-67-8428" "226-31-3081" "631-41-
3108" "123-19-1176" ...
$ Branch : chr [1:1000] "A" "C" "A" "A" ...
$ City : chr [1:1000] "Hyderabad" "Delhi" "Hyderabad" "Hyd
erabad" ...
$ Customer type : chr [1:1000] "Prime" "Standard" "Standard" "Prime
" ...
$ Gender : chr [1:1000] "Female" "Female" "Male" "Male" ...
$ Product line : chr [1:1000] "Health and beauty" "Electronic acce
ssories" "Home and lifestyle" "Health and beauty" ...
$ Unit price : num [1:1000] 74.7 15.3 46.3 58.2 86.3 ...
$ Quantity : num [1:1000] 7 5 7 8 7 7 6 10 2 3 ...
$ Tax 5% : num [1:1000] 26.14 3.82 16.22 23.29 30.21 ...
$ Total : num [1:1000] 549 80.2 340.5 489 634.4 ...
$ Date : chr [1:1000] "01-05-2024" "03-08-2024" "03-03-202
4" "1/27/2024" ...
$ Time : 'hms' num [1:1000] 13:08:00 10:29:00 13:23:00 20:
33:00 ...
..- attr(*, "units")= chr "secs"
$ Payment : chr [1:1000] "Ewallet" "Cash" "Credit card" "Ewal
let" ...
$ cogs : num [1:1000] 522.8 76.4 324.3 465.8 604.2 ...
$ gross margin percentage: num [1:1000] 4.76 4.76 4.76 4.76 4.76 ...
$ gross income : num [1:1000] 26.14 3.82 16.22 23.29 30.21 ...
$ Rating : num [1:1000] 9.1 9.6 7.4 8.4 5.3 4.1 5.8 8 7.2 5.
9 ...
- attr(*, "spec")=
.. cols(
.. `Invoice ID` = col_character(),
.. Branch = col_character(),
.. City = col_character(),
.. `Customer type` = col_character(),
.. Gender = col_character(),
.. `Product line` = col_character(),
.. `Unit price` = col_double(),
.. Quantity = col_double(),
.. `Tax 5%` = col_double(),
.. Total = col_double(),
.. Date = col_character(),
.. Time = col_time(format = ""),
.. Payment = col_character(),
.. cogs = col_double(),
.. `gross margin percentage` = col_double(),
.. `gross income` = col_double(),
.. Rating = col_double()
.. )
- attr(*, "problems")=<externalptr>

b)

[Link](data)
Invoice ID Branch City Customer type Gender Product line
[1,] FALSE FALSE FALSE FALSE FALSE FALSE
[2,] FALSE FALSE FALSE FALSE FALSE FALSE
[3,] FALSE FALSE FALSE FALSE FALSE FALSE
[4,] FALSE FALSE FALSE FALSE FALSE FALSE
[5,] FALSE FALSE FALSE FALSE FALSE FALSE
[6,] FALSE FALSE FALSE FALSE FALSE FALSE
[7,] FALSE FALSE FALSE FALSE FALSE FALSE
[8,] FALSE FALSE FALSE FALSE FALSE FALSE
[9,] FALSE FALSE FALSE FALSE FALSE FALSE
[10,] FALSE FALSE FALSE FALSE FALSE FALSE
[11,] FALSE FALSE FALSE FALSE FALSE FALSE
[12,] FALSE FALSE FALSE FALSE FALSE FALSE
[13,] FALSE FALSE FALSE FALSE FALSE FALSE
[14,] FALSE FALSE FALSE FALSE FALSE FALSE
[15,] FALSE FALSE FALSE FALSE FALSE FALSE
[16,] FALSE FALSE FALSE FALSE FALSE FALSE
[17,] FALSE FALSE FALSE FALSE FALSE FALSE
[18,] FALSE FALSE FALSE FALSE FALSE FALSE
[19,] FALSE FALSE FALSE FALSE FALSE FALSE
[20,] FALSE FALSE FALSE FALSE FALSE FALSE
[21,] FALSE FALSE FALSE FALSE FALSE FALSE
[22,] FALSE FALSE FALSE FALSE FALSE FALSE
[23,] FALSE FALSE FALSE FALSE FALSE FALSE
[24,] FALSE FALSE FALSE FALSE FALSE FALSE
[25,] FALSE FALSE FALSE FALSE FALSE FALSE
[26,] FALSE FALSE FALSE FALSE FALSE FALSE
[27,] FALSE FALSE FALSE FALSE FALSE FALSE
[28,] FALSE FALSE FALSE FALSE FALSE FALSE
[29,] FALSE FALSE FALSE FALSE FALSE FALSE
[30,] FALSE FALSE FALSE FALSE FALSE FALSE
[31,] FALSE FALSE FALSE FALSE FALSE FALSE
[32,] FALSE FALSE FALSE FALSE FALSE FALSE
[33,] FALSE FALSE FALSE FALSE FALSE FALSE
[34,] FALSE FALSE FALSE FALSE FALSE FALSE
[35,] FALSE FALSE FALSE FALSE FALSE FALSE
[36,] FALSE FALSE FALSE FALSE FALSE FALSE
[37,] FALSE FALSE FALSE FALSE FALSE FALSE
[38,] FALSE FALSE FALSE FALSE FALSE FALSE
[39,] FALSE FALSE FALSE FALSE FALSE FALSE
[40,] FALSE FALSE FALSE FALSE FALSE FALSE
[41,] FALSE FALSE FALSE FALSE FALSE FALSE
[42,] FALSE FALSE FALSE FALSE FALSE FALSE
[43,] FALSE FALSE FALSE FALSE FALSE FALSE
[44,] FALSE FALSE FALSE FALSE FALSE FALSE
[45,] FALSE FALSE FALSE FALSE FALSE FALSE
[46,] FALSE FALSE FALSE FALSE FALSE FALSE
[47,] FALSE FALSE FALSE FALSE FALSE FALSE
[48,] FALSE FALSE FALSE FALSE FALSE FALSE
[49,] FALSE FALSE FALSE FALSE FALSE FALSE
[50,] FALSE FALSE FALSE FALSE FALSE FALSE
[51,] FALSE FALSE FALSE FALSE FALSE FALSE
[52,] FALSE FALSE FALSE FALSE FALSE FALSE
[53,] FALSE FALSE FALSE FALSE FALSE FALSE
[54,] FALSE FALSE FALSE FALSE FALSE FALSE
[55,] FALSE FALSE FALSE FALSE FALSE FALSE
[56,] FALSE FALSE FALSE FALSE FALSE FALSE
[57,] FALSE FALSE FALSE FALSE FALSE FALSE
[58,] FALSE FALSE FALSE FALSE FALSE FALSE
Unit price Quantity Tax 5% Total Date Time Payment cogs
[1,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[2,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[3,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[4,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[5,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[6,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[7,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[8,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[9,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[10,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[11,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[12,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[13,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[14,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[15,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[16,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[17,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[18,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[19,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[20,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[21,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[22,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[23,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[24,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[25,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[26,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[27,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[28,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[29,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[30,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[31,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[32,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[33,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[34,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[35,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[36,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[37,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[38,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[39,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[40,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[41,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[42,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[43,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[44,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[45,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[46,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[47,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[48,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[49,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[50,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[51,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[52,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[53,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[54,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[55,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[56,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[57,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
[58,] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
gross margin percentage gross income Rating
[1,] FALSE FALSE FALSE
[2,] FALSE FALSE FALSE
[3,] FALSE FALSE FALSE
[4,] FALSE FALSE FALSE
[5,] FALSE FALSE FALSE
[6,] FALSE FALSE FALSE
[7,] FALSE FALSE FALSE
[8,] FALSE FALSE FALSE
[9,] FALSE FALSE FALSE
[10,] FALSE FALSE FALSE
[11,] FALSE FALSE FALSE
[12,] FALSE FALSE FALSE
[13,] FALSE FALSE FALSE
[14,] FALSE FALSE FALSE
[15,] FALSE FALSE FALSE
[16,] FALSE FALSE FALSE
[17,] FALSE FALSE FALSE
[18,] FALSE FALSE FALSE
[19,] FALSE FALSE FALSE
[20,] FALSE FALSE FALSE
[21,] FALSE FALSE FALSE
[22,] FALSE FALSE FALSE
[23,] FALSE FALSE FALSE
[24,] FALSE FALSE FALSE
[25,] FALSE FALSE FALSE
[26,] FALSE FALSE FALSE
[27,] FALSE FALSE FALSE
[28,] FALSE FALSE FALSE
[29,] FALSE FALSE FALSE
[30,] FALSE FALSE FALSE
[31,] FALSE FALSE FALSE
[32,] FALSE FALSE FALSE
[33,] FALSE FALSE FALSE
[34,] FALSE FALSE FALSE
[35,] FALSE FALSE FALSE
[36,] FALSE FALSE FALSE
[37,] FALSE FALSE FALSE
[38,] FALSE FALSE FALSE
[39,] FALSE FALSE FALSE
[40,] FALSE FALSE FALSE
[41,] FALSE FALSE FALSE
[42,] FALSE FALSE FALSE
[43,] FALSE FALSE FALSE
[44,] FALSE FALSE FALSE
[45,] FALSE FALSE FALSE
[46,] FALSE FALSE FALSE
[47,] FALSE FALSE FALSE
[48,] FALSE FALSE FALSE
[49,] FALSE FALSE FALSE
[50,] FALSE FALSE FALSE
[51,] FALSE FALSE FALSE
[52,] FALSE FALSE FALSE
[53,] FALSE FALSE FALSE
[54,] FALSE FALSE FALSE
[55,] FALSE FALSE FALSE
[56,] FALSE FALSE FALSE
[57,] FALSE FALSE FALSE
[58,] FALSE FALSE FALSE
[ reached getOption("[Link]") -- omitted 942 rows ]

>

c)

> summ=dfSummary(data)
|=================================================================| 100%
> summ
Data Frame Summary
data
Dimensions: 1000 x 17
Duplicates: 0

-----------------------------------------------------------------------------
------------------------------------------------
No Variable Stats / Values Freqs (% of Valid)
Graph Valid Missing
---- ------------------------- --------------------------- ------------------
---- ---------------------- ---------- ---------
1 Invoice ID 1. 101-17-6199 1 ( 0.1%)
1000 0
[character] 2. 101-81-4070 1 ( 0.1%)
(100.0%) (0.0%)
3. 102-06-2002 1 ( 0.1%)
4. 102-77-2261 1 ( 0.1%)
5. 105-10-6182 1 ( 0.1%)
6. 105-31-1824 1 ( 0.1%)
7. 106-35-6779 1 ( 0.1%)
8. 109-28-2512 1 ( 0.1%)
9. 109-86-4363 1 ( 0.1%)
10. 110-05-6330 1 ( 0.1%)
[ 990 others ] 990 (99.0%)
IIIIIIIIIIIIIIIIIII

2 Branch 1. A 340 (34.0%)


IIIIII 1000 0
[character] 2. B 332 (33.2%)
IIIIII (100.0%) (0.0%)
3. C 328 (32.8%)
IIIIII

3 City 1. Delhi 328 (32.8%)


IIIIII 1000 0
[character] 2. Hyderabad 340 (34.0%)
IIIIII (100.0%) (0.0%)
3. Pune 332 (33.2%)
IIIIII

4 Customer type 1. Prime 501 (50.1%)


IIIIIIIIII 1000 0
[character] 2. Standard 499 (49.9%)
IIIIIIIII (100.0%) (0.0%)

5 Gender 1. Female 501 (50.1%)


IIIIIIIIII 1000 0
[character] 2. Male 499 (49.9%)
IIIIIIIII (100.0%) (0.0%)

6 Product line 1. Electronic accessories 170 (17.0%)


III 1000 0
[character] 2. Fashion accessories 178 (17.8%)
III (100.0%) (0.0%)
3. Food and beverages 174 (17.4%)
III
4. Health and beauty 152 (15.2%)
III
5. Home and lifestyle 160 (16.0%)
III
6. Sports and travel 166 (16.6%)
III

7 Unit price Mean (sd) : 55.7 (26.5) 943 distinct value


s . . . . : 1000 0
[numeric] min < med < max:
: : : : : : : : : (100.0%) (0.0%)
10.1 < 55.2 < 100
: : : : : : : : :
IQR (CV) : 45.1 (0.5)
: : : : : : : : :

: : : : : : : : :

8 Quantity Mean (sd) : 5.5 (2.9) 1 : 112 (11.2%)


II 1000 0
[numeric] min < med < max: 2 : 91 ( 9.1%)
I (100.0%) (0.0%)
1 < 5 < 10 3 : 90 ( 9.0%)
I
IQR (CV) : 5 (0.5) 4 : 109 (10.9%)
II
5 : 102 (10.2%)
II
6 : 98 ( 9.8%)
I
7 : 102 (10.2%)
II
8 : 85 ( 8.5%)
I
9 : 92 ( 9.2%)
I
10 : 119 (11.9%)
II

9 Tax 5% Mean (sd) : 15.4 (11.7) 990 distinct value


s : . 1000 0
[numeric] min < med < max:
: : (100.0%) (0.0%)
0.5 < 12.1 < 49.6
: : : .
IQR (CV) : 16.5 (0.8)
: : : : : .

: : : : : : : : . .

10 Total Mean (sd) : 323 (245.9) 990 distinct value


s : . 1000 0
[numeric] min < med < max:
: : (100.0%) (0.0%)
10.7 < 253.8 < 1042.7
: : : .
IQR (CV) : 346.9 (0.8)
: : : : : .

: : : : : : : : . .

11 Date 1. 02-07-2024 20 ( 2.0%)


1000 0
[character] 2. 2/15/2024 19 ( 1.9%)
(100.0%) (0.0%)
3. 01-08-2024 18 ( 1.8%)
4. 03-02-2024 18 ( 1.8%
)
5. 3/14/2024 18 ( 1.8%)
6. 03-05-2024 17 ( 1.7%)
7. 1/23/2024 17 ( 1.7%)
8. 1/25/2024 17 ( 1.7%)
9. 1/26/2024 17 ( 1.7%)
10. 03-09-2024 16 ( 1.6%)
[ 79 others ] 823 (82.3%)
IIIIIIIIIIIIIIII

12 Time min : 36000 506 distinct value


s . : . . . 1000 0
[hms, med : 55140
: : : : : : : : (100.0%) (0.0%)
difftime] max : 75540
: : : : : : : :
units : secs
: : : : : : : :

: : : : : : : :

13 Payment 1. Cash 344 (34.4%)


IIIIII 1000 0
[character] 2. Credit card 311 (31.1%)
IIIIII (100.0%) (0.0%)
3. Ewallet 345 (34.5%)
IIIIII

14 cogs Mean (sd) : 307.6 (234.2) 990 distinct value


s : . 1000 0
[numeric] min < med < max:
: : (100.0%) (0.0%)
10.2 < 241.8 < 993
: : : .
IQR (CV) : 330.4 (0.8)
: : : : : .

: : : : : : : : . .
15 gross margin percentage 1 distinct value 4.76!: 1000 (100.0
%) IIIIIIIIIIIIIIIIIIII 1000 0
[numeric] ! rounded
(100.0%) (0.0%)

16 gross income Mean (sd) : 15.4 (11.7) 990 distinct value


s : . 1000 0
[numeric] min < med < max:
: : (100.0%) (0.0%)
0.5 < 12.1 < 49.6
: : : .
IQR (CV) : 16.5 (0.8)
: : : : : .

: : : : : : : : . .

17 Rating Mean (sd) : 7 (1.7) 61 distinct values


: . : : . . . . 1000 0
[numeric] min < med < max:
: : : : : : : : . : (100.0%) (0.0%)
4 < 7 < 10
: : : : : : : : : :
IQR (CV) : 3 (0.2)
: : : : : : : : : :

: : : : : : : : : :
-----------------------------------------------------------------------------
------------------------------------------------
> desstat=descr(data)
> desstat
Non-numerical variable(s) ignored: Invoice ID, Branch, City, Customer type, G
ender, Product line, Date, Time, PaymentDescriptive Statistics
data
N: 1000

cogs gross income gross margin percentage Quanti


ty Rating Tax 5%
----------------- --------- -------------- ------------------------- --------
-- --------- ---------
Mean 307.59 15.38 4.76 5.
51 6.97 15.38
[Link] 234.18 11.71 0.00 2.
92 1.72 11.71
Min 10.17 0.51 4.76 1.
00 4.00 0.51
Q1 117.89 5.89 4.76 3.
00 5.50 5.89
Median 241.76 12.09 4.76 5.
00 7.00 12.09
Q3 449.21 22.46 4.76 8.
00 8.50 22.46
Max 993.00 49.65 4.76 10.
00 10.00 49.65
MAD 222.65 11.13 0.00 2.
97 2.22 11.13
IQR 330.41 16.52 0.00 5.
00 3.00 16.52
CV 0.76 0.76 0.00 0.
53 0.25 0.76
Skewness 0.89 0.89 NaN 0.
01 0.01 0.89
[Link] 0.08 0.08 0.08 0.
08 0.08 0.08
Kurtosis -0.09 -0.09 NaN -1.
22 -1.16 -0.09
[Link] 1000.00 1000.00 1000.00 1000.
00 1000.00 1000.00
N 1000.00 1000.00 1000.00 1000.
00 1000.00 1000.00
[Link] 100.00 100.00 100.00 100.
00 100.00 100.00

Table: Table continues below

Total Unit price


----------------- --------- ------------
Mean 322.97 55.67
[Link] 245.89 26.49
Min 10.68 10.08
Q1 123.79 32.85
Median 253.85 55.23
Q3 471.67 77.94
Max 1042.65 99.96
MAD 233.78 33.37
IQR 346.93 45.06
CV 0.76 0.48
Skewness 0.89 0.01
[Link] 0.08 0.08
Kurtosis -0.09 -1.22
[Link] 1000.00 1000.00
N 1000.00 1000.00
[Link] 100.00 100.00

d)

> cont_table <- xtabs(~cogs + City, data = supermarket_sales)


> cont_table
City
cogs Delhi Hyderabad Pune
10.17 1 0 0
12.09 0 1 0
12.54 1 0 0
12.78 1 0 0
13.98 1 0 0
15.34 0 1 0
15.43 1 0 0
15.5 0 1 0
16.28 1 0 0
17.75 0 0 1
18.28 0 1 0
18.33 0 1 0
19.15 0 0 1
19.7 0 1 0
21.32 0 1 0
21.58 1 0 0
22.38 1 0 0
22.62 1 0 0
22.96 1 0 0
24.06 0 1 0
25 0 1 0
25.29 0 1 0
25.45 0 0 1
25.46 1 0 0
25.52 0 1 0
27.07 0 0 1
28.78 1 0 0
28.96 0 1 0
29.52 0 0 1
29.74 1 0 0
30.24 1 0 0
30.41 1 0 0
30.61 0 1 0
30.62 0 1 0
30.74 1 0 0
30.98 1 0 0
31.77 0 0 1
31.84 0 1 0
31.9 1 0 0
32.32 0 0 1
32.98 0 0 1
33.52 0 0 1
33.63 0 0 1
34.81 0 0 1
35.82 0 1 0
35.89 1 0 0
37 1 0 0
38.42 1 0 0
38.6 0 1 0
39.01 0 0 1
39.12 0 0 1
39.42 1 0 0
39.48 0 0 1
39.75 0 0 1
40.35 1 0 0
41.78 0 1 0
42.24 1 0 0
42.47 0 1 0
42.85 1 0 0
42.96 0 1 0
43.74 0 0 1
44.46 0 0 1
45.58 0 1 0
46.2 1 0 0
46.41 0 1 0
46.96 0 1 0
47.07 0 1 0
47.4 0 1 0
47.44 0 0 1
48.61 1 0 0
48.71 1 0 0
50.62 0 0 1
50.8 1 0 0
51.36 0 0 1
51.47 1 0 0
52.35 1 0 0
52.38 0 1 0
52.42 1 0 0
52.65 1 0 0
53.22 1 0 0
53.45 0 1 0
53.72 0 0 1
53.78 0 0 1
54.24 0 0 1
54.36 0 0 1
54.45 0 0 1
54.95 1 0 0
55.12 0 0 1
55.45 0 1 0
56.5 1 0 0
57.92 0 0 1
59.05 1 0 0
60.25 1 0 0
60.3 0 0 1
60.87 1 0 0
60.95 1 0 0
62.48 0 1 0
62.61 0 0 1
63.24 1 0 0
63.69 0 1 0
64.99 1 0 0
65.7 0 0 1
65.8 1 0 0
65.82 0 1 0
66.1 0 0 1
66.35 0 1 0
66.4 0 0 1
66.66 0 0 1
66.94 1 0 0
67.77 0 0 1
68.12 1 0 0
68.16 1 0 0
68.58 0 1 0
68.95 0 1 0
68.98 1 0 0
69.4 0 0 1
69.46 0 1 0
70.56 0 1 0
70.91 0 1 0
71.15 0 1 0
71.2 0 0 1
71.48 0 0 1
71.88 0 0 1
71.95 0 1 0
72.17 0 0 1
72.32 0 0 1
72.52 0 1 0
72.72 0 1 0
72.93 1 0 0
73.1 0 1 0
73.26 0 1 0
73.5 1 0 0
73.96 0 0 1
73.97 0 0 1
74.07 0 1 0
74.1 0 1 0
74.22 1 0 0
74.29 1 0 0
74.7 1 0 0
74.86 1 0 0
74.97 0 0 1
75.38 0 1 0
75.82 0 0 1
75.88 1 0 0
76.4 1 0 0
76.54 0 0 1
76.82 0 1 0
77.1 0 1 0
77.52 0 1 0
78.78 0 0 1
78.94 0 1 0
79.44 0 1 0
79.74 0 1 0
80.6 0 0 1
80.71 0 1 0
80.72 0 0 1
80.93 1 0 0
81.06 1 0 0
81.24 0 0 1
81.44 1 0 0
81.51 1 0 0
81.66 1 0 0
82.14 0 0 1
82.5 0 0 1
83.08 1 1 0
84.16 1 0 0
84.48 0 1 0
84.83 1 0 0
86 0 0 1
86.27 1 0 0
86.38 0 1 0
86.5 0 1 0
86.54 1 0 0
86.72 0 0 1
87.05 1 0 0
87.2 1 0 0
87.4 1 0 0
87.45 0 0 1
87.9 0 1 0
88.04 0 1 0
88.15 0 0 1
88.31 0 0 1
88.45 0 0 1
88.61 1 0 0
88.68 0 1 0
88.85 0 0 1
89.28 0 1 1
89.69 0 1 0
89.7 0 1 0
89.75 1 0 0
91.11 0 0 1
91.3 0 1 0
91.35 0 0 1
91.56 0 1 0
91.61 0 1 0
91.98 1 0 0
92.04 0 1 0
92.78 0 0 1
93.16 0 1 0
93.22 0 1 0
93.36 0 0 1
93.38 0 0 1
94.6 0 0 1
94.8 0 0 1
95 0 1 0
95.15 0 1 0
95.36 0 1 0
95.7 1 0 0
96.11 0 0 1
96.8 0 0 1
96.96 0 0 1
97.16 0 1 0
97.52 1 0 0
97.94 0 1 0
98.13 0 0 1
98.2 0 0 1
98.22 0 0 1
98.7 0 1 0
98.84 1 0 0
98.88 1 0 0
99.69 1 0 0
99.84 0 0 1
101.43 1 0 0
101.52 0 0 1
101.9 1 0 0
102.04 0 0 1
102.2 0 0 1
104.85 0 1 0
104.88 0 0 1
106.88 0 0 1
108.16 0 1 0
109.6 0 1 0
109.7 0 0 1
110.61 0 0 1
111.34 0 0 1
112.22 1 0 0
112.44 0 0 1
112.62 1 0 0
113.24 0 1 0
113.58 0 0 1
114.44 0 0 1
114.9 1 0 0
115.36 1 0 0
115.78 0 0 1
115.8 1 0 0
116.06 0 1 0
116.64 1 0 0
116.69 1 0 0
119.1 1 0 0
119.54 0 1 0
119.68 0 0 1
119.72 0 0 1
119.73 0 0 1
119.98 1 0 0
121.2 1 0 0
121.74 0 1 0
121.92 0 0 1
122.31 0 0 1
123.84 0 1 0
123.85 0 0 1
124.65 1 0 0
124.96 1 0 0
125.64 1 0 0
125.74 1 0 0
126.25 1 0 0
126.44 1 0 0
127 0 0 1
127.08 1 0 0
127.54 0 0 1
128.91 0 0 1
129 0 1 0
129.12 0 1 0
129.66 0 0 1
130.48 0 0 1
131.3 1 0 0
131.55 0 1 0
132.06 0 0 1
132.36 0 0 1
133.26 1 0 0
133.7 0 1 0
133.95 0 1 0
135 0 0 1
135.24 0 1 0
136.14 0 1 0
136.4 0 1 0
137.13 0 0 1
137.22 1 0 0
138.06 0 0 1
138.16 0 0 1
138.48 0 0 1
138.65 0 1 0
138.66 1 0 0
138.8 1 0 0
139.02 0 0 1
139.26 0 0 1
139.36 0 0 1
139.65 0 1 0
139.95 0 1 0
140.64 0 1 0
140.76 0 1 0
141.6 0 1 0
141.88 1 0 0
141.9 0 0 1
142.25 0 1 0
142.95 1 0 0
143.26 0 1 0
143.6 1 0 0
144.08 0 0 1
144.27 0 0 1
144.3 0 0 1
144.78 0 0 1
145.44 0 1 0
145.5 0 0 1
145.56 0 0 1
145.76 1 0 0
146.79 1 0 0
147.04 0 0 1
147.8 0 0 1
148.24 1 0 0
148.6 0 1 0
152.58 0 1 0
152.8 1 0 0
153.2 0 0 1
153.86 0 1 0
154 1 0 0
155 0 1 0
155.24 0 0 1
155.46 0 1 0
155.82 0 1 0
156.6 0 1 0
156.84 0 0 1
157.02 0 1 0
157.26 0 0 1
[ reached getOption("[Link]") -- omitted 657 rows ]

f)

xtabs(~Ra ng,data)

h)

You might also like