Delhi Technological University
Delhi School Of Management
Data Analytics Lab Record
MBA-115
Session: 2024-25
Submitted To: Submitted By:
DR. ABHINAV CHAUDARY Meenakshi Vashisth
24/DMBA/137
INDEX
S.NO DATE NAME REMARKS
1. MARKS ALLOTMENT
2. EMI CALCULATOR
3. INCOME TAX CALCULATOR
4. LINEAR REGRESSION
5. MULTIPLE REGRESSION
6. T ONE SAMPLE TEST
7. T TWO SAMPLE TEST
8. DICE
MARKS ALLOTMENT
MARKS AWARDED
FORMULA
SUBJECT WISE
STUDENT WISE
HOME LOAN (EMI
CALCULATOR)
EMI CALCULATOR
FROMULA
INCOME TAX CALCULATOR
Q . INCOME TAX CALCULATOR
FORMULA
LINEAR REGRESSION
MULTIPLE REGRESSION
LINEAR REGRESSION
Q. A company XYZ believes that its Annual Profit depends on its Expenditure for
Research. The information for the preceding six years is given below. Estimate the
annual profit when the expenditure for research is made. The information for the
preceding six years if given below. Estimate the Annual Profit when the
Expenditure for research is 6 units.
GRAPH
Q. A Manufacturer of Bicycles for children in the age group of two to four years
commissioned a market research firm to understand the factors that influenced
the demand for its product. After some detailed studies, the market research firm
concluded that the demand was a function of the number of newly born children
in the city. Based on this assumption and given data collected for a residential
area in the city. Estimate the demand for Bicycles if the number of newly born
children is 150 and 250.
FORMULA
GRAPH
MULTIPLE REGRESSION
Q. The Sale of Ice-Cream is dependent on the Budget and the Temprature. Past
data for six days is given the table. What is the sales estimate if the Budget is 6
and the Temprature for the next day is likely to be 32?
OUTPUT
Q. The Quaterly Demand for washing machines from a retailer depends upon the
amount spent by him on advertising and promotion and the demand for washing
machines in the entire city. The information about demand of washing machines
in the entire city. The estimated sales for washing machines in the city in the
forthcoming quarter is 250 and the retailer plans to spend Rs 15000 in
advertisement and sales promotion in the same quarter. Estimate the sales of the
retailer in the coming quarter?
OUTPUT
T ONE SAMPLE TEST
Q. A business school in its advertisements claims that the average salary of its
graduates in a particular lean year is at par with the average salaries offered
at the top five business schools. A sample of 30 graduates, from the business
school whose claim was to be verified, was taken at random. Their salaries
are given in Table
OUTPUT
T TWO SAMPLE TEST
Q. A study was conducted to compare the efficiency of the workers of two mines,
one with private ownership and the other with government ownership.
The researcher was of the view that there is no significant difference in
their efficiency levels. Total tonnage of the mineral mined by a worker in
one shift was chosen as the criteria to assess his efficiency.
Twenty workers from the private sector mine and 24 from the government-
owned mine were selected and their average output per shift was recorded.
The data obtained is given in Table
OUTPUT
DICE
Q. A dice is thrown 132 times and the following observations were noted. Find out
whether the dice was biased or unbiased.
1 comes 16 times, 2 comes 20 times, 3 comes 25 times, 4 comes 14 times, 5
comes 29 times, 6 comes 28 times
FORMULA
OUTPUT
