Index Product Name Sale Price Mrp Discount P Ratings Reviews Star RatingRam

1 SE (White, 64 GB) 29999 39900 24 95807 8154 4.5 2 GB

2 SE (Black, 128 GB) 34999 44900 22 95909 8161 4.5 2 GB
3 SE (White, 128 GB) 34999 44900 22 95807 8154 4.5 2 GB
4 SE (Red, 128 GB) 34999 44900 22 95909 8161 4.5 2 GB
5 SE (Black, 64 GB) 29999 39900 24 95909 8161 4.5 4 GB
6 SE (White, 256 GB) (Incl 44999 54900 18 95909 8161 4.5 2 GB
7 8 Plus (Gold, 64 GB) 49900 49900 0 3431 356 4.6 2 GB
8 8 Plus (Space Grey, 256 G 84900 84900 0 3431 356 4.6 2 GB
9 8 Plus (Silver, 256 GB) 84900 84900 0 3431 356 4.6 2 GB
10 8 (Silver, 256 GB) 77000 77000 0 11202 794 4.5 2 GB
11 8 (Gold, 256 GB) 77000 77000 0 11202 794 4.5 2 GB
12 8 Plus (Silver, 64 GB) 49900 49900 0 3431 356 4.6 2 GB
13 8 Plus (Space Grey, 64 GB 49900 49900 0 3431 356 4.6 2 GB
14 8 (Space Grey, 256 GB) 77000 77000 0 11202 794 4.5 2 GB
15 XS Max (Silver, 64 GB) 89900 89900 0 1454 149 4.6 4 GB
16 XR ((PRODUCT)RED, 128 G 41999 52900 20 79512 6796 4.6 4 GB
17 XR (Black, 64 GB) (Inclu 39999 47900 16 79512 6796 4.6 4 GB
18 XR (Coral, 128 GB) (Incl 41999 52900 20 79582 6804 4.6 4 GB
19 XR (Black, 128 GB) (Incl 41999 52900 20 79512 6796 4.6 3 GB
20 XR (White, 128 GB) (Incl 41999 52900 20 79512 6796 4.6 4 GB
21 11 Pro Max (Gold, 256 GB 131900 131900 0 1078 101 4.7 4 GB
22 11 Pro Max (Gold, 64 GB) 117100 117100 0 1078 101 4.7 4 GB
23 11 Pro Max (Midnight Gr 131900 131900 0 1078 101 4.7 4 GB
24 11 Pro Max (Space Grey, 117100 117100 0 1078 101 4.7 4 GB
25 11 Pro (Midnight Green, 74999 106600 29 7088 523 4.6 4 GB
26 11 Pro (Space Grey, 512 117900 140300 15 7088 523 4.6 4 GB
27 11 Pro Max (Midnight Gr 117100 117100 0 1078 101 4.7 4 GB
28 11 Pro (Midnight Green, 117900 140300 15 7088 523 4.6 4 GB
29 11 Pro (Space Grey, 256 99900 121300 17 7081 522 4.6 4 GB
30 11 (White, 128 GB) 54999 59900 8 43707 3357 4.6 4 GB
31 11 (Red, 128 GB) 54999 59900 8 43707 3357 4.6 4 GB
32 11 (Black, 128 GB) 54999 59900 8 43470 3331 4.6 4 GB
33 11 (Purple, 64 GB) 46999 54900 14 43470 3331 4.6 4 GB
34 11 (White, 64 GB) 46999 54900 14 43470 3331 4.6 4 GB
35 11 (Black, 64 GB) 46999 54900 14 43470 3331 4.6 4 GB
36 11 (Red, 64 GB) 46999 54900 14 43470 3331 4.6 4 GB
37 12 Pro (Silver, 512 GB) 140900 149900 6 542 42 4.5 4 GB
38 12 Pro Max (Pacific Blue, 130900 139900 6 580 45 4.6 6 GB
39 12 Mini (White, 128 GB) 64900 74900 13 740 64 4.5 4 GB
40 12 Pro (Graphite, 256 GB) 120900 129900 6 545 42 4.5 6 GB
41 12 Mini (White, 64 GB) 59900 69900 14 740 64 4.5 4 GB
42 12 (White, 128 GB) 75900 84900 10 2101 180 4.6 6 GB
43 12 Pro (Graphite, 128 GB) 110900 119900 7 545 42 4.5 6 GB
44 12 Pro Max (Graphite, 25 130900 139900 6 580 45 4.6 6 GB
45 12 Pro Max (Graphite, 12 120900 129900 6 580 45 4.6 6 GB
46 12 Mini (Black, 128 GB) 64900 74900 13 730 63 4.5 4 GB
47 12 Mini (Blue, 128 GB) 64900 74900 13 730 63 4.5 4 GB
48 12 (Black, 128 GB) 75900 84900 10 2101 180 4.6 6 GB
49 12 (Blue, 128 GB) 75900 84900 10 2101 180 4.6 6 GB
50 12 Pro Max (Silver, 128 G 120900 129900 6 580 45 4.6 6 GB
51 12 Mini (Red, 64 GB) 59900 69900 14 740 64 4.5 6 GB
52 12 Pro Max (Gold, 128 GB 120900 129900 6 580 45 4.6 6 GB
53 12 (Green, 128 GB) 75900 84900 10 2092 178 4.6 6 GB
54 12 Pro (Pacific Blue, 512 140900 149900 6 545 42 4.5 4 GB
55 12 (White, 64 GB) 70900 79900 11 2101 180 4.6 6 GB
56 12 (Black, 64 GB) 70900 79900 11 2092 178 4.6 6 GB
57 12 (Red, 128 GB) 75900 84900 10 2101 180 4.6 6 GB
58 12 Mini (Black, 64 GB) 59900 69900 14 740 64 4.5 4 GB
59 12 Pro (Pacific Blue, 128 110900 119900 7 545 42 4.5 6 GB
60 12 Pro Max (Pacific Blue, 120900 129900 6 580 45 4.6 6 GB
61 12 Pro Max (Silver, 256 G 130900 139900 6 580 45 4.6 6 GB
62 12 Pro Max (Gold, 256 GB 130900 139900 6 580 45 4.6 6 GB
Units sold (In millions)
22
22
22
22
22
22
12
23
10
19
4
7
13
16
28
15
10
9
24
17
17
15
10
9
18
21
17
8
17
19
13
23
25
34
19
7
3
4
1
5
7
2
10
3
5
2
7
 4
6
13
7
2
5
12
4
8
7
8
9
2
4
5
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
 Descriptive Statistics
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
scriptive Statistics
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
Question 1 What is the average value of an iPhone?
₹ 88,058
 Descriptive Statistics
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
criptive Statistics
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
Question 2 Which discount percentage apple used most?
6
 Descriptive Statistics
Index Product Name Sale Price Mrp
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
scriptive Statistics
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
0 1078 101 4.7 4 GB 17
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 580 45 4.6 6 GB 4
10 2101 180 4.6 6 GB 2
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 11202 794 4.5 2 GB 16
6 542 42 4.5 4 GB 3
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
7 545 42 4.5 6 GB 10
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
14 740 64 4.5 6 GB 7
6 545 42 4.5 4 GB 12
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
Question 3 Which model has most rating?
I have used sort option here for finding most rating
 Descriptive Statistics
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
criptive Statistics
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
Question 4 Average star rating of iPhone?
4.6
 Descriptive Statistics
Index Product Name Sale Price Mrp
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
scriptive Statistics
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
14 43470 3331 4.6 4 GB 34
0 1454 149 4.6 4 GB 28
14 43470 3331 4.6 4 GB 25
20 79512 6796 4.6 3 GB 24
0 3431 356 4.6 2 GB 23
8 43470 3331 4.6 4 GB 23
15 7088 523 4.6 4 GB 21
0 11202 794 4.5 2 GB 19
8 43707 3357 4.6 4 GB 19
14 43470 3331 4.6 4 GB 19
29 7088 523 4.6 4 GB 18
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 17
17 7081 522 4.6 4 GB 17
0 11202 794 4.5 2 GB 16
20 79512 6796 4.6 4 GB 15
0 1078 101 4.7 4 GB 15
0 3431 356 4.6 2 GB 13
8 43707 3357 4.6 4 GB 13
6 580 45 4.6 6 GB 13
0 3431 356 4.6 2 GB 12
6 545 42 4.5 4 GB 12
0 3431 356 4.6 2 GB 10
16 79512 6796 4.6 4 GB 10
0 1078 101 4.7 4 GB 10
7 545 42 4.5 6 GB 10
20 79582 6804 4.6 4 GB 9
0 1078 101 4.7 4 GB 9
7 545 42 4.5 6 GB 9
15 7088 523 4.6 4 GB 8
11 2092 178 4.6 6 GB 8
14 740 64 4.5 4 GB 8
0 3431 356 4.6 2 GB 7
14 43470 3331 4.6 4 GB 7
14 740 64 4.5 4 GB 7
13 730 63 4.5 4 GB 7
14 740 64 4.5 6 GB 7
10 2101 180 4.6 6 GB 7
24 95909 8161 4.5 4 GB 6
10 2101 180 4.6 6 GB 6
22 95807 8154 4.5 2 GB 5
6 545 42 4.5 6 GB 5
6 580 45 4.6 6 GB 5
10 2092 178 4.6 6 GB 5
6 580 45 4.6 6 GB 5
22 95909 8161 4.5 2 GB 4
18 95909 8161 4.5 2 GB 4
0 11202 794 4.5 2 GB 4
6 580 45 4.6 6 GB 4
10 2101 180 4.6 6 GB 4
11 2101 180 4.6 6 GB 4
6 580 45 4.6 6 GB 4
24 95807 8154 4.5 2 GB 3
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 3
22 95909 8161 4.5 2 GB 2
10 2101 180 4.6 6 GB 2
13 730 63 4.5 4 GB 2
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 2
13 740 64 4.5 4 GB 1
Question 5 Average unit sold of an iPhone in million
10.5

Question 6 Maximum unit sold of an iPhone in million.

iPhone 11 with 34 million unit
 DATA Visualization
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
ATA Visualization
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
Units sold (In millions)
Question 7 Represent the sales of iPhone (model wise)?

24
Sales (Model Wise)
300 272

250

200
145
Unit sold
104 150
104 103
100

50 24

0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58 61

Axis Title
103

272
145
49 52 55 58 61
 DATA Visualization
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900

2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900

3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900

4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
ATA Visualization
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3

22 95909 8161 4.5 2 GB 2

22 95807 8154 4.5 2 GB 5

22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
Question 8 Show the price increment of iPhone?
 DATA Visualization
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
ATA Visualization
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6 4.75
18 95909 8161 4.5 2 GB 4
4.7
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23 4.65
0 3431 356 4.6 2 GB 10

Star rating
4.6
0 11202 794 4.5 2 GB 19
4.55
0 11202 794 4.5 2 GB 4 4.5 4.5
0 3431 356 4.6 2 GB 7 4.5

0 3431 356 4.6 2 GB 13 4.45

0 11202 794 4.5 2 GB 16 4.4
0 1454 149 4.6 4 GB 28 0

20 79512 6796 4.6 4 GB 15

16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
 Question 9 Show the star rating trend with scattered chart

4.75
4.7 4.7 4.7 4.7 4.7
4.7
4.65
4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6
Star rating

4.6
4.55
4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5
4.5
4.45
4.4
0 10 20 30
 Star rating
4.7

4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6

4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5

30 40 50 60
models
4.6 4.6 4.6 4.6 4.6 4.6 4.6

4.5 4.5 4.5

60 70
 Advance Excel Tool
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
vance Excel Tool
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
Question 10 Which model has the maximum star rating?
Here I have used greater than conditional formating to find the max star rating
 Advance Excel Tool
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
vance Excel Tool
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
Question 11 What is the most expensive model of iPhone?
12 pro
Here I have used greater than conditional formating to find the most expensive model
 Advance Excel Tool
Index Product Name Sale Price Mrp
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
vance Excel Tool
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
29 7088 523 4.6 4 GB 18
24 95807 8154 4.5 2 GB 3
24 95909 8161 4.5 4 GB 6
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
20 79512 6796 4.6 4 GB 15
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
18 95909 8161 4.5 2 GB 4
17 7081 522 4.6 4 GB 17
16 79512 6796 4.6 4 GB 10
15 7088 523 4.6 4 GB 21
15 7088 523 4.6 4 GB 8
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
14 740 64 4.5 4 GB 7
14 740 64 4.5 6 GB 7
14 740 64 4.5 4 GB 8
13 740 64 4.5 4 GB 1
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 2
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
10 2092 178 4.6 6 GB 5
10 2101 180 4.6 6 GB 7
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
7 545 42 4.5 6 GB 10
7 545 42 4.5 6 GB 9
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
6 545 42 4.5 6 GB 5
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
6 580 45 4.6 6 GB 13
6 580 45 4.6 6 GB 2
6 545 42 4.5 4 GB 12
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
0 1078 101 4.7 4 GB 17
Question 12Maximum discount percentage that apple offers
29%
 Advance Excel Tool
Index Product Name Sale Price Mrp
1 SE (White, 64 GB) ₹ 29,999 ₹ 39,900
2 SE (Black, 128 GB) ₹ 34,999 ₹ 44,900
3 SE (White, 128 GB) ₹ 34,999 ₹ 44,900
4 SE (Red, 128 GB) ₹ 34,999 ₹ 44,900
5 SE (Black, 64 GB) ₹ 29,999 ₹ 39,900
6 SE (White, 256 GB) (Includes EarPods, Power Adapter) ₹ 44,999 ₹ 54,900
7 8 Plus (Gold, 64 GB) ₹ 49,900 ₹ 49,900
8 8 Plus (Space Grey, 256 GB) ₹ 84,900 ₹ 84,900
9 8 Plus (Silver, 256 GB) ₹ 84,900 ₹ 84,900
10 8 (Silver, 256 GB) ₹ 77,000 ₹ 77,000
11 8 (Gold, 256 GB) ₹ 77,000 ₹ 77,000
12 8 Plus (Silver, 64 GB) ₹ 49,900 ₹ 49,900
13 8 Plus (Space Grey, 64 GB) ₹ 49,900 ₹ 49,900
14 8 (Space Grey, 256 GB) ₹ 77,000 ₹ 77,000
15 XS Max (Silver, 64 GB) ₹ 89,900 ₹ 89,900
16 XR ((PRODUCT)RED, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
17 XR (Black, 64 GB) (Includes EarPods, Power Adapter) ₹ 39,999 ₹ 47,900
18 XR (Coral, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
19 XR (Black, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
20 XR (White, 128 GB) (Includes EarPods, Power Adapter) ₹ 41,999 ₹ 52,900
21 11 Pro Max (Gold, 256 GB) ₹ 131,900 ₹ 131,900
22 11 Pro Max (Gold, 64 GB) ₹ 117,100 ₹ 117,100
23 11 Pro Max (Midnight Green, 256 GB) ₹ 131,900 ₹ 131,900
24 11 Pro Max (Space Grey, 64 GB) ₹ 117,100 ₹ 117,100
25 11 Pro (Midnight Green, 64 GB) ₹ 74,999 ₹ 106,600
26 11 Pro (Space Grey, 512 GB) ₹ 117,900 ₹ 140,300
27 11 Pro Max (Midnight Green, 64 GB) ₹ 117,100 ₹ 117,100
28 11 Pro (Midnight Green, 512 GB) ₹ 117,900 ₹ 140,300
29 11 Pro (Space Grey, 256 GB) ₹ 99,900 ₹ 121,300
30 11 (White, 128 GB) ₹ 54,999 ₹ 59,900
31 11 (Red, 128 GB) ₹ 54,999 ₹ 59,900
32 11 (Black, 128 GB) ₹ 54,999 ₹ 59,900
33 11 (Purple, 64 GB) ₹ 46,999 ₹ 54,900
34 11 (White, 64 GB) ₹ 46,999 ₹ 54,900
35 11 (Black, 64 GB) ₹ 46,999 ₹ 54,900
36 11 (Red, 64 GB) ₹ 46,999 ₹ 54,900
37 12 Pro (Silver, 512 GB) ₹ 140,900 ₹ 149,900
38 12 Pro Max (Pacific Blue, 256 GB) ₹ 130,900 ₹ 139,900
39 12 Mini (White, 128 GB) ₹ 64,900 ₹ 74,900
40 12 Pro (Graphite, 256 GB) ₹ 120,900 ₹ 129,900
41 12 Mini (White, 64 GB) ₹ 59,900 ₹ 69,900
42 12 (White, 128 GB) ₹ 75,900 ₹ 84,900
43 12 Pro (Graphite, 128 GB) ₹ 110,900 ₹ 119,900
44 12 Pro Max (Graphite, 256 GB) ₹ 130,900 ₹ 139,900
45 12 Pro Max (Graphite, 128 GB) ₹ 120,900 ₹ 129,900
46 12 Mini (Black, 128 GB) ₹ 64,900 ₹ 74,900
47 12 Mini (Blue, 128 GB) ₹ 64,900 ₹ 74,900
48 12 (Black, 128 GB) ₹ 75,900 ₹ 84,900
49 12 (Blue, 128 GB) ₹ 75,900 ₹ 84,900
50 12 Pro Max (Silver, 128 GB) ₹ 120,900 ₹ 129,900
51 12 Mini (Red, 64 GB) ₹ 59,900 ₹ 69,900
52 12 Pro Max (Gold, 128 GB) ₹ 120,900 ₹ 129,900
53 12 (Green, 128 GB) ₹ 75,900 ₹ 84,900
54 12 Pro (Pacific Blue, 512 GB) ₹ 140,900 ₹ 149,900
55 12 (White, 64 GB) ₹ 70,900 ₹ 79,900
56 12 (Black, 64 GB) ₹ 70,900 ₹ 79,900
57 12 (Red, 128 GB) ₹ 75,900 ₹ 84,900
58 12 Mini (Black, 64 GB) ₹ 59,900 ₹ 69,900
59 12 Pro (Pacific Blue, 128 GB) ₹ 110,900 ₹ 119,900
60 12 Pro Max (Pacific Blue, 128 GB) ₹ 120,900 ₹ 129,900
61 12 Pro Max (Silver, 256 GB) ₹ 130,900 ₹ 139,900
62 12 Pro Max (Gold, 256 GB) ₹ 130,900 ₹ 139,900
vance Excel Tool
Discount Percentage Ratings Reviews Star Rating Ram Units sold (In millions)
24 95807 8154 4.5 2 GB 3
22 95909 8161 4.5 2 GB 2
22 95807 8154 4.5 2 GB 5
22 95909 8161 4.5 2 GB 4
24 95909 8161 4.5 4 GB 6
18 95909 8161 4.5 2 GB 4
0 3431 356 4.6 2 GB 12
0 3431 356 4.6 2 GB 23
0 3431 356 4.6 2 GB 10
0 11202 794 4.5 2 GB 19
0 11202 794 4.5 2 GB 4
0 3431 356 4.6 2 GB 7
0 3431 356 4.6 2 GB 13
0 11202 794 4.5 2 GB 16
0 1454 149 4.6 4 GB 28
20 79512 6796 4.6 4 GB 15
16 79512 6796 4.6 4 GB 10
20 79582 6804 4.6 4 GB 9
20 79512 6796 4.6 3 GB 24
20 79512 6796 4.6 4 GB 17
0 1078 101 4.7 4 GB 17
0 1078 101 4.7 4 GB 15
0 1078 101 4.7 4 GB 10
0 1078 101 4.7 4 GB 9
29 7088 523 4.6 4 GB 18
15 7088 523 4.6 4 GB 21
0 1078 101 4.7 4 GB 17
15 7088 523 4.6 4 GB 8
17 7081 522 4.6 4 GB 17
8 43707 3357 4.6 4 GB 19
8 43707 3357 4.6 4 GB 13
8 43470 3331 4.6 4 GB 23
14 43470 3331 4.6 4 GB 25
14 43470 3331 4.6 4 GB 34
14 43470 3331 4.6 4 GB 19
14 43470 3331 4.6 4 GB 7
6 542 42 4.5 4 GB 3
6 580 45 4.6 6 GB 4
13 740 64 4.5 4 GB 1
6 545 42 4.5 6 GB 5
14 740 64 4.5 4 GB 7
10 2101 180 4.6 6 GB 2
7 545 42 4.5 6 GB 10
6 580 45 4.6 6 GB 3
6 580 45 4.6 6 GB 5
13 730 63 4.5 4 GB 2
13 730 63 4.5 4 GB 7
10 2101 180 4.6 6 GB 4
10 2101 180 4.6 6 GB 6
6 580 45 4.6 6 GB 13
14 740 64 4.5 6 GB 7
6 580 45 4.6 6 GB 2
10 2092 178 4.6 6 GB 5
6 545 42 4.5 4 GB 12
11 2101 180 4.6 6 GB 4
11 2092 178 4.6 6 GB 8
10 2101 180 4.6 6 GB 7
14 740 64 4.5 4 GB 8
7 545 42 4.5 6 GB 9
6 580 45 4.6 6 GB 2
6 580 45 4.6 6 GB 4
6 580 45 4.6 6 GB 5
Question 13 Below 10% sales unit model wise.
SE (Black, 128 GB)
12 Mini (White, 128 GB)
12 (White, 128 GB)
12 Mini (Black, 128 GB)
12 Pro Max (Pacific Blue, 128 GB)