Steps to be

followed
1
2

Guidelines
Copy the data and paste it as value in a separate excel sheet before started analysing
Save the excel file on your Name and UID No
Save the excel file time to time, all the process you are doing in the excel write the steps in detail in Excel as we
exam paper (Hardcopy)
If we find any copy case of data or writeup and if we are not convinenced with excel edit history we will not con
both the excel sheet for evaluation & marked ZERO.

Duration of the exam - 1 hour

Ensure you will write all the steps on excel as well as on Hardcopy paper
Question Paper consist of 2 parts
Part A - Answer any 2 out of 3 questions - 5 Marks each - Total - 10 Marks
Part B - Answer any 1 out of 2 Questions - 10 Marks each - Total - 10 Marks
 Manufacturing Cost 13719 Steps to be followed
Price Demand 1
Selling Price 17219 18941 2
Demand 144238 119718 3
4
Calculate the Revenue 5
Calculate the Profit 6
Calculate PED Value
Price Demand
Calculate Demand using linear
equation for the Price 18510 1
Calculate Demand using Power
equation for the Price 19802 2
Calculate Demand using Polynominal
equation for the Price 16874 3
Copy the data and paste it as value in a separate excel sheet
Save the excel file on your Name and UID No
Save the excel file time to time, all the process you are doing in the excel write the steps in detail in Excel as we
If we find any copy case of data or writeup and if we are not convinenced with excel edit history we will not co
Ensure all the requried charts are created along with equations
Write all the equation on exam paper and excel sheet

Find the PED value

Find Revenue, Profit based on the given data

Calculate the demand based on Linear, Power & Polynominal Demand curve and find the demand for the give
Cus No. Soap Shampoo Perfume Tooth Paste Steps to be followed
10091 35 31 96 53 1 Copy the data and paste it as value
10092 61 10 91 40 2 Save the excel file on your Name an
10093 31 31 93 46 3 Save the excel file time to time, all th
10094 48 25 104 33 4 If we find any copy case of data or w
10095 48 14 234 46 5 Ensure all the requried charts are c
10096 35 29 114 46 6 Write all the equation on exam pape
10097 53 19 152 33
10098 34 22 113 46
10099 55 26 149 30 1 Prepare the product bundle
10100 66 31 168 37 2 Find the Total revenue if customer purcha
10101 62 22 249 37 3 Optimize the total revenue
10102 37 33 249 53 4 Interpert which product. Product combina
10103 63 33 101 39
10104 67 11 163 56
10105 51 19 142 36
10106 38 30 153 37
10107 37 33 207 41
10108 48 25 122 55
10109 34 17 223 59
10110 72 23 201 50
10111 56 18 81 60
10112 58 28 166 45
10113 35 16 220 58
10114 73 25 246 38
10115 38 29 105 43
10116 57 12 230 31
10117 67 10 162 43
10118 60 29 135 42
10119 61 23 198 52
10120 35 27 195 57
10121 48 33 88 44
10122 51 34 153 58
10123 67 14 206 37
10124 35 32 154 38
10125 30 10 176 35
10126 72 27 141 40
10127 49 30 169 47
10128 72 34 163 47
10129 31 14 222 40
10130 65 29 184 51
10131 40 12 137 48
10132 31 25 240 53
10133 61 19 135 60
10134 75 14 177 32
10135 55 30 117 39
10136 72 17 110 59
10137 52 27 138 49
10138 52 24 243 35
10139 68 21 135 51
10140 37 34 206 45
10141 49 16 201 35
10142 73 22 96 50
10143 50 27 222 56
10144 49 35 218 53
10145 56 29 217 57
10146 66 18 124 48
10147 52 32 155 30
10148 44 27 103 49
10149 52 19 224 38
10150 67 12 167 38
10151 72 34 139 58
10152 45 18 230 32
10153 36 30 202 47
10154 53 13 85 49
10155 52 17 156 56
10156 45 33 165 36
10157 34 13 221 54
10158 64 13 97 33
10159 37 25 237 42
10160 59 20 231 36
10161 59 18 129 60
10162 56 17 162 58
10163 64 21 181 60
10164 33 24 157 60
10165 50 27 122 54
10166 38 16 136 50
10167 72 32 132 57
10168 40 22 90 55
10169 53 18 225 56
10170 40 23 101 47
10171 39 29 215 38
10172 67 22 211 60
10173 52 13 239 53
10174 52 24 82 43
10175 41 23 228 37
10176 57 12 210 42
10177 74 17 156 50
10178 31 24 247 58
10179 47 15 119 58
10180 56 30 189 53
10181 50 25 243 34
10182 43 21 174 52
10183 55 32 180 51
10184 38 20 210 33
10185 32 12 124 31
10186 42 21 107 56
10187 73 12 163 40
10188 50 14 230 37
10189 48 35 165 54
e data and paste it as value in a separate excel sheet
excel file on your Name and UID No
excel file time to time, all the process you are doing in the excel write the steps in detail in Excel as well as in exam paper
d any copy case of data or writeup and if we are not convinenced with excel edit history we will not consider both the exc
all the requried charts are created along with equations
l the equation on exam paper and excel sheet

e product bundle
Total revenue if customer purchase your product
the total revenue
which product. Product combination will bring more sales to the business
l as well as in exam paper (Hardcopy)
not consider both the excel sheet for evaluation & marked ZERO.
Customer ID Actual Date Amount Steps to be followed
99837 2/24/2025 63000 1
99696 2/13/2025 57500 2

99945 3/14/2025 72000 3

99834 5/18/2025 104500 4

99603 5/11/2025 101000
99760 7/24/2025 138000
100000 9/22/2025 168000
99959 10/9/2025 176500 1
99894 12/31/2024 35500 2
99870 9/1/2025 157500 3
99881 6/6/2025 114000
99808 3/24/2025 77000
99860 11/16/2024 13000
99783 8/13/2025 148000
99609 2/18/2025 60000
99645 12/4/2024 22000
99615 4/9/2025 85000
99676 3/26/2025 78000
99889 3/4/2025 67000
99670 12/26/2024 33000
99734 6/29/2025 125500
99592 8/1/2025 142000
99812 8/18/2025 150500
99882 5/7/2025 99000
99826 8/2/2025 142500
99909 8/28/2025 155500
99799 7/20/2025 136000
99572 7/28/2025 140000
99751 2/7/2025 54500
99902 3/27/2025 78500
99916 3/10/2025 70000
99630 5/19/2025 105000
99949 2/19/2025 60500
99915 8/22/2025 152500
99638 7/19/2025 135500
99528 3/23/2025 76500
99719 11/19/2024 14500
99682 7/12/2025 132000
99606 1/10/2025 40500
99625 5/3/2025 97000
99620 9/16/2025 165000
99524 4/19/2025 90000
99751 5/31/2025 111000
99671 8/20/2025 151500
99709 11/16/2024 13000
99893 10/6/2025 175000
99982 3/27/2025 78500
99693 12/28/2024 34000
99647 6/18/2025 120000
99922 11/6/2024 8000
99998 7/3/2025 127500
99659 10/28/2024 3500
99976 5/25/2025 108000
99699 7/22/2025 137000
99860 12/11/2024 25500
99599 12/22/2024 31000
99744 12/21/2024 30500
99872 9/16/2025 165000
99772 11/1/2024 5500
99774 4/15/2025 88000
99584 11/4/2024 7000
99989 9/7/2025 160500
99590 5/17/2025 104000
99897 4/27/2025 94000
99651 4/4/2025 82500
99739 12/31/2024 35500
99743 4/20/2025 90500
99531 3/23/2025 76500
99771 2/20/2025 61000
99738 1/7/2025 39000
99605 4/29/2025 95000
99569 3/16/2025 73000
99793 10/13/2025 178500
99916 5/17/2025 104000
99550 9/7/2025 160500
99899 9/8/2025 161000
99967 2/13/2025 57500
99713 2/13/2025 57500
99665 2/22/2025 62000
99660 10/17/2025 180500
99892 3/4/2025 67000
99756 11/13/2024 11500
99839 11/13/2024 11500
99809 4/1/2025 81000
99689 3/13/2025 71500
99911 12/7/2024 23500
99589 5/23/2025 107000
99912 11/7/2024 8500
99996 9/10/2025 162000
99643 9/11/2025 162500
99929 6/18/2025 120000
99562 8/14/2025 148500
99620 4/29/2025 95000
99547 5/16/2025 103500
99831 1/25/2025 48000
99587 11/29/2024 19500
99543 4/21/2025 91000
99766 10/14/2025 179000
99596 1/27/2025 49000
99508 8/27/2025 155000
99855 2/16/2025 59000
99997 4/24/2025 92500
99701 3/25/2025 77500
99925 6/3/2025 112500
99691 4/3/2025 82000
99891 8/10/2025 146500
99812 9/23/2025 168500
99771 11/5/2024 7500
99800 6/30/2025 126000
99820 1/21/2025 46000
99757 8/30/2025 156500
99548 12/7/2024 23500
99708 9/16/2025 165000
99834 5/13/2025 102000
99695 9/11/2025 162500
99534 11/21/2024 15500
99507 6/17/2025 119500
99626 11/16/2024 13000
99580 1/1/2025 36000
99639 9/19/2025 166500
99566 2/8/2025 55000
99678 6/4/2025 113000
99648 7/24/2025 138000
99511 9/18/2025 166000
99580 9/8/2025 161000
99573 11/3/2024 6500
99662 9/27/2025 170500
99880 1/17/2025 44000
99501 3/5/2025 67500
99592 5/3/2025 97000
99777 12/16/2024 28000
99862 1/21/2025 46000
99633 5/22/2025 106500
99526 1/12/2025 41500
99627 5/1/2025 96000
99505 2/10/2025 56000
99695 8/9/2025 146000
99778 11/4/2024 7000
99878 2/9/2025 55500
99799 2/22/2025 62000
99747 12/21/2024 30500
99915 2/23/2025 62500
99516 8/25/2025 154000
99930 9/27/2025 170500
99877 12/28/2024 34000
99607 5/5/2025 98000
99516 12/20/2024 30000
99867 9/6/2025 160000
99549 7/2/2025 127000
99850 5/20/2025 105500
99697 7/14/2025 133000
99850 1/9/2025 40000
99778 1/26/2025 48500
99509 2/27/2025 64500
99918 3/6/2025 68000
99526 9/21/2025 167500
99964 3/1/2025 65500
99875 6/17/2025 119500
99590 9/14/2025 164000
99538 9/5/2025 159500
99940 11/7/2024 8500
99586 8/22/2025 152500
99523 8/4/2025 143500
99779 12/24/2024 32000
99657 4/17/2025 89000
99552 8/28/2025 155500
99845 8/2/2025 142500
99954 9/14/2025 164000
99528 8/23/2025 153000
99612 4/4/2025 82500
99581 1/5/2025 38000
99798 11/7/2024 8500
99550 1/18/2025 44500
99867 8/15/2025 149000
99642 4/1/2025 81000
99867 2/10/2025 56000
99527 1/25/2025 48000
99873 4/30/2025 95500
99846 11/13/2024 11500
99584 10/2/2025 173000
99775 1/17/2025 44000
99909 9/14/2025 164000
99872 1/19/2025 45000
99620 5/21/2025 106000
99509 7/29/2025 140500
99763 7/26/2025 139000
99804 3/31/2025 80500
99793 11/15/2024 12500
99780 6/18/2025 120000
99865 4/18/2025 89500
99517 5/9/2025 100000
99733 4/14/2025 87500
99728 8/2/2025 142500
99669 5/18/2025 104500
99856 5/6/2025 98500
99510 12/18/2024 29000
99724 1/31/2025 51000
99773 5/13/2025 102000
99895 11/15/2024 12500
99890 2/28/2025 65000
99940 3/1/2025 65500
99834 2/17/2025 59500
99857 9/12/2025 163000
99621 8/26/2025 154500
99511 9/12/2025 163000
99618 7/8/2025 130000
99911 1/30/2025 50500
99520 8/3/2025 143000
99880 10/22/2024 500
99609 9/20/2025 167000
99777 3/8/2025 69000
99636 7/6/2025 129000
99636 4/2/2025 81500
99919 7/16/2025 134000
99753 2/8/2025 55000
99753 12/13/2024 26500
99809 12/19/2024 29500
99621 7/13/2025 132500
99865 7/3/2025 127500
99860 2/5/2025 53500
99964 7/25/2025 138500
99565 4/10/2025 85500
99809 7/16/2025 134000
99569 6/25/2025 123500
99552 1/25/2025 48000
99677 9/22/2025 168000
99859 1/11/2025 41000
99597 7/2/2025 127000
99896 10/8/2025 176000
99797 8/12/2025 147500
99528 7/29/2025 140500
99838 10/14/2025 179000
99843 1/20/2025 45500
99886 11/25/2024 17500
99674 9/11/2025 162500
99912 4/27/2025 94000
99533 3/22/2025 76000
99993 3/24/2025 77000
99896 1/24/2025 47500
99948 9/5/2025 159500
99681 6/28/2025 125000
99666 6/3/2025 112500
99972 3/19/2025 74500
99760 1/20/2025 45500
99835 10/24/2024 1500
99626 4/21/2025 91000
99816 6/9/2025 115500
99861 12/14/2024 27000
99998 10/9/2025 176500
99554 11/29/2024 19500
99791 8/26/2025 154500
99822 3/12/2025 71000
99655 12/8/2024 24000
99720 1/22/2025 46500
99597 7/10/2025 131000
99700 8/28/2025 155500
99806 10/27/2024 3000
99806 10/27/2024 3000
99984 12/27/2024 33500
99525 5/17/2025 104000
99971 12/16/2024 28000
99820 8/4/2025 143500
99920 7/23/2025 137500
99898 7/26/2025 139000
99960 2/4/2025 53000
99553 6/19/2025 120500
99670 5/11/2025 101000
99644 3/22/2025 76000
99792 8/16/2025 149500
99708 8/20/2025 151500
99968 6/5/2025 113500
99781 8/27/2025 155000
99810 10/28/2024 3500
99966 2/12/2025 57000
99688 1/30/2025 50500
99838 2/7/2025 54500
99980 9/22/2025 168000
99796 7/27/2025 139500
99762 1/8/2025 39500
99709 10/26/2024 2500
99893 6/16/2025 119000
99827 5/21/2025 106000
99934 7/24/2025 138000
99737 6/10/2025 116000
99678 5/8/2025 99500
99571 10/4/2025 174000
99730 5/15/2025 103000
99585 10/27/2024 3000
99617 1/14/2025 42500
99685 8/31/2025 157000
99626 9/3/2025 158500
99964 2/23/2025 62500
99878 8/14/2025 148500
99655 11/22/2024 16000
99622 12/25/2024 32500
99945 8/30/2025 156500
99860 7/13/2025 132500
99801 3/2/2025 66000
99963 8/18/2025 150500
99975 7/17/2025 134500
99830 12/10/2024 25000
99626 10/21/2025 182500
99641 7/19/2025 135500
99775 11/28/2024 19000
99689 2/24/2025 63000
99516 12/2/2024 21000
99865 3/5/2025 67500
99875 2/14/2025 58000
99957 11/3/2024 6500
99830 11/2/2024 6000
99740 7/22/2025 137000
99972 4/4/2025 82500
99531 4/2/2025 81500
99938 2/1/2025 51500
99893 8/8/2025 145500
99939 4/29/2025 95000
99691 8/30/2025 156500
99794 6/7/2025 114500
99943 7/19/2025 135500
99848 7/19/2025 135500
99815 5/12/2025 101500
99980 1/2/2025 36500
99952 3/3/2025 66500
99607 11/4/2024 7000
99621 8/28/2025 155500
99741 6/22/2025 122000
99506 6/24/2025 123000
99633 1/12/2025 41500
99701 7/12/2025 132000
99871 11/13/2024 11500
99809 4/25/2025 93000
99711 12/5/2024 22500
99784 1/14/2025 42500
99723 7/10/2025 131000
99697 6/5/2025 113500
99742 7/30/2025 141000
99561 3/22/2025 76000
99617 10/8/2025 176000
99739 7/10/2025 131000
99517 5/22/2025 106500
99544 1/7/2025 39000
99979 8/4/2025 143500
99502 9/27/2025 170500
99779 3/3/2025 66500
99953 12/27/2024 33500
99678 10/11/2025 177500
99680 3/26/2025 78000
99659 10/28/2024 3500
99668 4/29/2025 95000
99885 1/30/2025 50500
99950 1/28/2025 49500
99651 10/26/2024 2500
99595 8/23/2025 153000
99858 7/29/2025 140500
99994 2/2/2025 52000
99996 10/6/2025 175000
99802 5/25/2025 108000
99997 12/21/2024 30500
99880 7/15/2025 133500
99689 1/19/2025 45000
99778 9/27/2025 170500
99581 12/2/2024 21000
99640 4/6/2025 83500
99766 9/15/2025 164500
99572 5/13/2025 102000
99698 11/27/2024 18500
99991 10/21/2025 182500
99837 5/20/2025 105500
99826 7/3/2025 127500
99707 12/12/2024 26000
99790 5/4/2025 97500
99841 12/24/2024 32000
99562 11/24/2024 17000
99837 6/14/2025 118000
99823 6/23/2025 122500
99605 6/6/2025 114000
99987 12/25/2024 32500
99577 3/4/2025 67000
99845 10/14/2025 179000
99505 2/3/2025 52500
99664 11/14/2024 12000
99904 1/1/2025 36000
99732 11/11/2024 10500
99505 5/12/2025 101500
99814 3/9/2025 69500
99981 8/25/2025 154000
99948 2/16/2025 59000
99990 12/11/2024 25500
99959 3/17/2025 73500
99787 10/27/2024 3000
99761 4/22/2025 91500
99529 12/21/2024 30500
99504 2/20/2025 61000
99654 9/1/2025 157500
99895 7/24/2025 138000
99630 12/16/2024 28000
99764 9/29/2025 171500
99653 6/29/2025 125500
99721 3/10/2025 70000
99856 2/6/2025 54000
99785 1/28/2025 49500
99882 2/19/2025 60500
99875 6/23/2025 122500
99944 9/20/2025 167000
99696 11/2/2024 6000
99528 3/27/2025 78500
99922 3/29/2025 79500
99607 12/14/2024 27000
99643 7/30/2025 141000
99605 6/30/2025 126000
99705 10/30/2024 4500
99959 12/23/2024 31500
99953 1/22/2025 46500
99636 3/29/2025 79500
99745 11/12/2024 11000
99948 5/15/2025 103000
99767 9/10/2025 162000
99914 10/21/2025 182500
99999 12/2/2024 21000
99852 2/25/2025 63500
99884 6/25/2025 123500
99912 12/15/2024 27500
99779 5/27/2025 109000
99945 7/28/2025 140000
99657 9/2/2025 158000
99838 3/14/2025 72000
99537 10/9/2025 176500
99658 2/2/2025 52000
99940 10/22/2024 500
99715 2/22/2025 62000
99949 7/21/2025 136500
99943 9/24/2025 169000
99706 8/7/2025 145000
99648 3/6/2025 68000
99623 9/21/2025 167500
99937 6/5/2025 113500
99648 10/15/2025 179500
99787 4/21/2025 91000
99612 5/21/2025 106000
99740 7/21/2025 136500
99878 3/18/2025 74000
99993 8/13/2025 148000
99993 8/30/2025 156500
99975 4/3/2025 82000
99752 9/7/2025 160500
99927 1/5/2025 38000
99634 10/13/2025 178500
99538 4/25/2025 93000
99649 3/9/2025 69500
99696 4/21/2025 91000
99623 11/15/2024 12500
99999 1/26/2025 48500
99577 4/27/2025 94000
99991 6/7/2025 114500
99633 2/7/2025 54500
99778 11/4/2024 7000
99702 4/30/2025 95500
99797 3/24/2025 77000
99839 6/3/2025 112500
99522 10/24/2024 1500
99791 7/26/2025 139000
99592 1/1/2025 36000
99742 5/1/2025 96000
99986 6/9/2025 115500
99902 12/17/2024 28500
99676 5/9/2025 100000
99975 4/3/2025 82000
99985 1/26/2025 48500
99746 1/5/2025 38000
99667 3/10/2025 70000
99741 2/12/2025 57000
99891 6/15/2025 118500
99568 8/11/2025 147000
99874 8/13/2025 148000
99772 9/16/2025 165000
99620 10/5/2025 174500
99584 7/21/2025 136500
99699 5/24/2025 107500
99876 5/16/2025 103500
99962 4/20/2025 90500
99802 10/21/2025 182500
99590 10/22/2024 500
99866 8/30/2025 156500
99751 12/22/2024 31000
99755 12/27/2024 33500
99966 4/15/2025 88000
99833 8/2/2025 142500
99790 12/7/2024 23500
99926 5/1/2025 96000
99508 2/27/2025 64500
99921 2/17/2025 59500
99587 2/10/2025 56000
99842 11/17/2024 13500
99906 10/27/2024 3000
99781 3/30/2025 80000
99635 6/26/2025 124000
99976 8/17/2025 150000
99723 6/22/2025 122000
99598 7/10/2025 131000
99763 9/26/2025 170000
Copy the data and paste it as value in a separate excel sheet
Save the excel file on your Name and UID No
Save the excel file time to time, all the process you are doing in the excel write the steps in detail in
Excel as well as in exam paper (Hardcopy)
If we find any copy case of data or writeup and if we are not convinenced with excel edit history
we will not consider both the excel sheet for evaluation & marked ZERO.

Find the R of RFM

Calculte the R F M Score
Segment the date into 3 groups and interpert
Case Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q1
1 3 4 2 4 4 4 5 4 5 2 2 5 1 3 4 Q2
2 5 3 3 2 3 3 1 3 1 2 5 2 5 5 3 Q3
3 4 5 4 1 3 3 1 1 1 5 5 1 3 3 3 Q4
4 5 3 4 4 4 1 2 3 4 2 3 2 3 5 5 Q5
5 4 3 2 5 4 4 2 4 4 3 2 2 3 1 1 Q6
6 4 1 4 3 3 3 5 1 3 2 4 1 4 2 4 Q7
7 5 5 4 5 5 4 3 1 4 5 4 3 1 4 2 Q8
8 3 1 2 1 2 1 1 4 4 5 1 2 5 3 2 Q9
9 1 5 3 1 4 1 1 1 5 5 2 1 5 2 3 Q10
10 1 2 1 4 2 5 5 4 1 2 1 2 5 1 2 Q11
11 3 1 5 5 3 5 4 2 2 1 4 5 4 4 5 Q12
12 4 5 1 2 3 2 4 5 5 1 2 5 2 2 5 Q13
13 1 2 3 3 1 5 1 5 3 1 2 1 2 5 1 Q14
14 5 4 4 2 2 2 3 3 3 2 5 5 2 3 1 Q15
15 2 2 2 3 1 4 5 4 2 1 3 1 5 4 2
16 3 3 1 4 1 5 5 1 5 2 2 1 4 3 1

17 1 2 5 5 1 1 5 1 2 4 4 3 5 3 1
18 1 4 1 4 3 1 1 3 2 5 5 1 4 3 3
19 5 5 4 5 4 3 4 2 1 2 3 4 1 2 4 Steps to be followed
20 5 4 5 4 5 1 3 2 2 1 1 1 2 2 5 1
21 5 1 1 5 3 3 4 2 5 3 5 1 3 5 1 2
22 5 3 2 2 5 1 1 2 2 1 5 3 4 5 4 3
23 3 4 2 1 4 3 4 2 3 5 3 2 2 3 4 4
24 3 4 2 2 2 3 2 3 3 1 2 1 4 3 5
25 2 3 3 3 4 5 1 4 4 2 3 1 2 4 1
26 3 1 4 5 3 5 2 3 3 1 2 1 3 1 1
27 2 4 5 2 3 2 4 5 5 2 3 1 1 1 4
28 2 2 4 2 3 3 4 4 4 3 4 3 5 2 5
29 1 1 4 3 4 4 5 2 2 5 1 5 2 2 3
30 4 4 5 5 5 2 5 4 5 5 3 2 4 2 5
31 3 1 1 2 2 5 1 3 3 4 4 4 5 3 3
32 1 2 2 5 5 1 3 5 4 2 2 3 5 5 1
33 4 3 1 5 1 2 3 5 3 5 4 4 5 1 2
34 2 1 3 1 4 1 5 1 2 3 5 3 5 3 1
35 2 2 3 1 2 1 2 5 3 4 2 4 5 1 2
36 4 2 5 1 5 1 4 4 3 1 1 1 4 5 3
37 2 2 2 3 1 4 3 5 5 3 3 3 5 1 1
38 4 3 1 4 4 5 2 4 4 1 5 5 2 1 3
39 4 3 3 1 5 2 2 1 4 5 5 5 1 5 5
40 5 4 4 2 2 2 4 1 2 5 5 2 3 1 4
41 1 1 1 4 4 1 5 2 3 5 2 2 2 5 1
42 1 3 3 4 3 1 3 1 4 1 5 2 1 5 3
43 1 2 3 5 3 5 3 5 4 3 5 2 4 1 4
44 2 5 4 5 3 5 2 3 5 1 5 2 1 5 4
45 3 5 3 1 4 5 1 1 1 3 2 4 1 3 1
46 4 5 5 2 3 1 3 4 3 1 1 5 1 1 3
47 5 1 1 4 1 2 2 3 4 4 4 3 4 5 4
48 2 4 2 3 1 5 5 3 4 5 2 5 4 3 4
49 5 2 3 5 5 3 1 1 4 1 5 5 4 5 4
50 1 3 1 4 2 1 1 2 3 5 2 1 1 4 2
51 5 4 3 2 5 1 5 1 4 1 5 5 1 4 1
52 1 5 4 4 5 3 4 4 4 3 2 3 2 5 5
53 3 1 5 2 5 2 2 1 5 2 1 5 2 2 3
54 3 2 5 5 2 1 5 1 5 2 4 4 1 1 1
55 1 1 1 2 4 1 1 5 5 2 3 1 1 4 1
56 2 3 3 1 4 4 5 4 4 2 1 4 2 2 4
57 1 1 2 3 3 5 2 5 5 5 3 3 2 3 5
58 4 3 4 1 5 3 4 1 3 1 2 1 4 4 3
59 4 2 1 3 2 4 4 4 2 2 4 2 1 2 4
60 3 5 1 1 1 3 3 1 1 4 4 3 4 5 2
61 1 4 2 4 2 1 1 1 2 3 1 3 5 3 3
62 4 5 4 4 2 5 5 4 5 5 4 1 3 5 5
63 3 4 2 3 3 1 1 2 3 1 4 1 3 5 5
64 3 1 4 3 5 2 4 2 5 5 2 1 3 3 1
65 3 2 4 3 2 3 4 1 3 4 3 2 2 2 2
66 4 1 4 5 2 2 1 1 3 1 2 5 3 5 4
67 2 1 5 2 2 2 3 1 4 1 1 2 5 1 2
68 5 2 5 4 1 4 1 1 2 5 4 1 2 4 5
69 3 1 3 1 4 4 1 4 5 2 4 4 3 3 1
70 4 3 1 1 1 3 2 5 1 4 5 2 5 4 4
71 1 2 1 2 2 4 2 3 4 3 1 1 5 1 2
72 2 4 3 1 1 1 5 5 5 4 4 3 4 3 1
73 1 3 1 2 3 5 4 3 5 5 4 3 4 3 2
74 4 1 1 3 4 5 5 3 4 3 4 2 5 3 4
75 5 4 4 2 5 2 2 3 2 2 4 4 4 2 1
76 3 1 2 5 2 5 3 3 4 3 1 1 3 5 2
77 1 4 1 5 5 4 4 3 1 3 3 2 1 2 5
78 5 3 2 4 1 1 3 1 5 3 3 1 2 4 2
79 5 2 3 5 5 4 3 5 2 5 2 1 2 2 5
80 2 1 4 3 3 4 2 3 1 2 3 3 3 1 5
81 1 3 1 2 2 3 1 2 5 5 1 5 5 1 4
82 4 3 3 1 4 3 4 3 4 4 2 5 1 1 2
83 1 1 3 5 1 1 2 3 4 4 5 1 5 5 1
84 4 4 1 3 5 4 3 3 5 4 3 2 4 2 5
85 1 3 5 1 1 5 4 5 2 3 2 2 3 5 3
86 1 3 1 2 5 1 5 5 1 1 3 4 4 4 4
 87 3 5 2 5 3 1 4 5 2 5 3 4 5 2 3
88 2 1 1 2 1 3 5 5 1 4 5 1 4 3 5
89 2 1 4 5 2 1 3 5 5 4 3 5 5 4 5
90 3 4 1 2 4 4 5 3 3 4 2 3 2 2 5
91 1 3 2 1 4 3 5 4 3 4 3 2 1 1 2
92 1 5 2 1 1 2 3 5 5 1 5 1 2 3 3
93 5 2 1 4 3 2 5 2 1 3 2 3 1 3 3
94 5 2 1 5 2 2 3 3 2 2 2 4 3 3 2
95 3 4 2 5 5 2 1 2 1 1 1 1 2 3 4
96 3 3 2 4 4 5 5 5 1 2 5 1 1 2 3
97 5 1 5 1 5 4 2 2 3 3 2 5 1 3 2
98 5 5 3 4 4 4 1 3 4 4 5 3 1 4 4
99 3 1 5 5 1 3 4 5 1 2 2 5 5 2 4
100 2 1 2 4 3 4 2 3 5 5 3 3 1 3 2
 1. I prefer to skip breakfast as I do not have time in the morning.
2. I always keep ready-to-eat packets in my kitchen cupboard.
3. I like watching family-based TV serials.
4. A healthy and sumptuous breakfast is the best meal to have in a day.
5. Skill based education is the need of the hour in India.
6. Its better to buy packaged milk products.
7. I keep in touch with my friends on Facebook.
8. In today’s times a wife has got to work to support her husband.
9. Women’s empowerment is an essential step for any nation to grow.
10. Sunday evenings are for enjoying oneself.
11. Today the consumer is very conscious about the quality of a product.
12. I do not like making meals at home during weekends.
13. Mobile phones have become a very important part of an Indian’s life.
14. India in the next decade is going to be a force to reckon with.
15. The quality of Indian milk products has improved greatly in the last decade.

We have conducted the survey among with housewives and mothers to

understand health concerns based on food consumptions. The respondents had to
agree or disagree with each statement on a scale of 1 to 5. Create a customer
segment for the same and interpert the data

Steps to be followed
Copy the data and paste it as value in a separate excel sheet
Save the excel file on your Name and UID No
Save the excel file time to time, all the process you are doing in the excel write the steps in detail in Excel as we
If we find any copy case of data or writeup and if we are not convinenced with excel edit history we will not co
 detail in Excel as well as in exam paper (Hardcopy)
history we will not consider both the excel sheet for evaluation & marked ZERO.
Sr No. Age Gender Weight Height No of KM Running Speed Veg / Non-Veg
1 46 Male 101 180 6 5 Non-Veg
2 20 Female 110 187 3 7 Veg
3 16 Female 100 172 4 5 Non-Veg
4 26 Female 99 188 2 5 Non-Veg
5 38 Male 89 155 2 3 Non-Veg
6 13 Male 56 165 4 7 Non-Veg
7 46 Male 85 164 6 4 Veg
8 23 Male 90 174 3 6 Veg
9 27 Male 101 174 2 5 Veg
10 51 Female 88 188 6 4 Veg
11 59 Female 88 179 5 3 Non-Veg
12 12 Male 84 176 2 5 Non-Veg
13 35 Female 87 183 2 4 Non-Veg
14 56 Female 54 162 6 2 Non-Veg
15 49 Male 55 160 3 2 Veg
16 19 Female 70 158 4 7 Veg
17 23 Female 91 177 4 7 Non-Veg
18 52 Female 61 176 5 2 Non-Veg
19 33 Female 104 175 4 5 Veg
20 33 Male 66 171 2 3 Veg
21 31 Female 64 168 2 2 Non-Veg
22 46 Female 60 167 5 2 Non-Veg
23 20 Male 93 162 2 5 Veg
24 21 Male 50 156 3 7 Non-Veg
25 31 Male 80 169 4 4 Non-Veg
26 21 Female 92 176 2 9 Veg
27 44 Female 64 167 5 3 Non-Veg
28 40 Female 47 163 3 2 Veg
29 41 Male 74 183 5 4 Veg
30 25 Male 108 176 4 3 Non-Veg
31 24 Male 68 162 2 9 Non-Veg
32 55 Female 83 188 4 4 Veg
33 50 Male 64 159 5 4 Veg
34 33 Female 94 173 3 5 Non-Veg
35 44 Female 110 175 5 4 Veg
36 19 Female 87 189 3 5 Veg
37 60 Female 51 163 6 4 Non-Veg
38 45 Male 84 167 6 5 Non-Veg
39 20 Female 48 168 3 7 Veg
40 22 Male 72 190 4 8 Non-Veg
41 57 Female 105 172 5 5 Non-Veg
42 25 Female 46 167 4 3 Non-Veg
43 24 Female 78 180 4 7 Non-Veg
44 28 Male 67 164 3 2 Non-Veg
45 58 Male 104 170 4 5 Non-Veg
46 25 Female 91 168 3 4 Non-Veg
47 30 Male 105 187 4 4 Non-Veg
48 45 Male 81 159 4 4 Non-Veg
49 17 Male 105 180 3 9 Veg
50 13 Male 83 170 4 7 Veg
51 38 Female 86 162 2 3 Non-Veg
52 45 Female 68 189 4 5 Veg
53 55 Male 61 157 4 3 Veg
54 33 Female 67 159 3 2 Veg
55 39 Male 87 190 4 3 Non-Veg
56 43 Female 97 171 6 5 Non-Veg
57 47 Female 96 174 4 3 Veg
58 36 Female 95 183 3 2 Non-Veg
59 43 Male 88 167 4 5 Non-Veg
60 22 Male 77 161 4 7 Veg
61 42 Male 105 171 4 2 Non-Veg
62 31 Male 63 185 2 2 Veg
63 12 Male 104 179 4 7 Non-Veg
64 55 Male 66 185 4 5 Non-Veg
65 20 Male 88 184 3 8 Non-Veg
66 51 Female 94 184 4 4 Non-Veg
67 24 Male 88 175 2 9 Non-Veg
68 28 Male 98 183 4 4 Non-Veg
69 43 Male 98 184 6 2 Veg
70 29 Female 52 161 2 3 Non-Veg
71 56 Female 95 174 4 2 Non-Veg
72 24 Female 99 189 4 6 Non-Veg
73 32 Male 52 158 4 5 Veg
74 37 Male 70 165 3 5 Veg
75 20 Male 108 174 2 6 Veg
76 15 Male 53 163 3 8 Non-Veg
77 27 Female 102 184 2 5 Veg
78 37 Female 72 170 4 4 Veg
79 55 Male 63 165 6 5 Veg
80 33 Male 82 159 3 2 Veg
81 19 Male 91 162 4 6 Non-Veg
82 27 Female 85 165 3 4 Non-Veg
83 28 Female 58 161 3 5 Non-Veg
84 31 Female 53 157 4 4 Non-Veg
85 56 Female 85 155 5 5 Veg
86 46 Female 104 187 3 4 Non-Veg
87 23 Male 85 165 3 8 Veg
88 26 Female 80 186 3 2 Veg
89 16 Female 73 165 3 5 Non-Veg
 90 18 Female 95 165 3 5 Non-Veg
91 13 Female 58 169 3 8 Veg
92 51 Female 68 189 6 2 Veg
93 31 Female 72 172 2 5 Non-Veg
94 25 Male 89 178 2 4 Veg
95 14 Male 82 165 4 5 Non-Veg
96 44 Female 88 161 4 5 Non-Veg
97 53 Male 103 183 5 2 Veg
98 17 Female 86 180 4 9 Veg
99 36 Male 89 175 3 2 Non-Veg
100 60 Female 77 183 3 5 Non-Veg
101 37 Male 78 172 3 5 Non-Veg
102 48 Male 57 158 5 3 Veg
103 16 Male 63 175 2 9 Non-Veg
104 23 Male 104 176 4 7 Non-Veg
105 53 Male 97 188 3 3 Veg
106 13 Male 106 185 2 7 Non-Veg
107 17 Male 66 189 4 5 Veg
108 24 Female 67 173 2 6 Non-Veg
109 24 Female 81 182 4 8 Veg
110 51 Female 86 176 6 2 Non-Veg
111 24 Female 78 188 3 9 Veg
112 45 Male 50 158 6 5 Non-Veg
113 15 Female 58 161 3 7 Non-Veg
114 48 Male 96 176 6 3 Non-Veg
115 42 Female 96 180 3 3 Veg
116 52 Male 77 176 3 5 Non-Veg
117 35 Female 98 174 2 2 Non-Veg
118 18 Female 81 160 2 5 Non-Veg
119 13 Male 110 172 3 7 Non-Veg
120 26 Female 83 155 4 5 Non-Veg
121 18 Female 47 155 3 8 Veg
122 56 Male 86 160 6 3 Non-Veg
123 38 Female 88 182 2 4 Veg
124 39 Female 52 156 4 3 Non-Veg
125 15 Female 87 176 4 8 Veg
126 47 Female 89 167 6 3 Non-Veg
127 35 Male 90 172 2 4 Veg
128 16 Female 68 184 4 8 Non-Veg
129 21 Male 85 159 4 8 Non-Veg
130 45 Male 103 188 5 5 Non-Veg
131 59 Male 84 163 3 2 Veg
132 58 Female 62 183 5 2 Non-Veg
133 30 Female 95 178 3 4 Veg
134 37 Male 82 169 2 4 Veg
135 29 Female 87 174 3 4 Veg
136 30 Female 109 183 2 4 Veg
137 44 Female 109 177 6 5 Non-Veg
138 25 Female 78 161 3 3 Non-Veg
139 22 Female 58 164 2 7 Veg
140 33 Female 73 186 2 3 Non-Veg
141 45 Female 94 178 6 3 Non-Veg
142 34 Male 79 188 2 4 Veg
143 43 Male 67 185 3 2 Non-Veg
144 37 Female 81 187 3 2 Veg
145 49 Female 79 170 6 2 Veg
146 34 Male 96 171 4 2 Veg
147 13 Male 98 181 4 8 Non-Veg
148 59 Female 61 167 3 2 Non-Veg
149 48 Male 68 170 6 3 Non-Veg
150 44 Female 78 176 4 2 Veg
Calories Burned Steps to be followed
200 1 Copy the data and paste it as value in a separate excel sheet
144 2 Save the excel file on your Name and UID No
248 3 Save the excel file time to time, all the process you are doing in the
104 4 If we find any copy case of data or writeup and if we are not convin
145
290
179 1 Write a multiple regeression analsis equation
196 2 Perform Regression Analysis and interpert
150 3 Interpert the M value of all the variable
179 4 Calculate how much calories can be burned based on the parameter given
226 Age Gender Weight Height No of KMRunning
109 33 Male 96 181 2 4
97
248
160
230
275
288
284
125
110
265
75
155
208
100
283
224
258
300
133
178
181
223
235
164
194
176
184
190
212
277
207
136
251
165
279
265
191
186
122
183
210
224
231
279
193
173
191
270
228
87
205
269
217
273
140
237
250
79
271
211
186
203
143
213
109
282
218
148
300
134
181
299
243
204
219
185
181
208
126
283
85
96
272
184
297
225
165
206
162
191
140
277
132
106
197
126
285
190
215
222
149
253
156
147
129
103
168
278
176
179
108
227
195
256
112
278
259
253
154
200
173
115
222
113
279
143
75
94
283
99
203
153
241
236
250
143
178
240
parate excel sheet

cess you are doing in the excel write the steps in detail in Excel as well as in exam paper (Hardcopy)
p and if we are not convinenced with excel edit history we will not consider both the excel sheet for evaluation & marked

d on the parameter given

Veg / Non-Veg
Non-Veg
or evaluation & marked ZERO.