Business Analytics Quiz 2: 3 August 2025 (May 2025 term)

Data on “Urban Population (UP)” of a country and the “GDP” of the same country are collected. The “GDP” is captured as a percentage (that is “10.5%” is captured as “10.5”) and the “UP” is captured in crores of people (that is “1,20,00,000” is captured as “1.2”). From the raw data, the analyst has identified that the relation is non-linear. Hence, the analyst applies a natural logarithmic transformation on both variables (the independent variable is “GDP” and the dependent variable is “UP”). The transformed data is modelled as a Simple Linear Regression and the developed model is presented in Figure-1. Using this information, answer the given subquestions.

How many degrees of freedom will be present for the “Regression” term in the ANOVA table (nomenclature as per excel)?

Data on “Urban Population (UP)” of a country and the “GDP” of the same country are collected. The “GDP” is captured as a percentage (that is “10.5%” is captured as “10.5”) and the “UP” is captured in crores of people (that is “1,20,00,000” is captured as “1.2”). From the raw data, the analyst has identified that the relation is non-linear. Hence, the analyst applies a natural logarithmic transformation on both variables (the independent variable is “GDP” and the dependent variable is “UP”). The transformed data is modelled as a Simple Linear Regression and the developed model is presented in Figure-1. Using this information, answer the given subquestions.

If the GDP in 2024 was 15%, then what is the predicted “UP” (in crores of people) based on the SLR model? (Note: Enter your answer rounded to two decimal places. For example, if your answer is “1.235” then enter it as “1.24”)

Milo’s Bakery is famous for three products “BA Biscuits (BAB)”, “TA Controversy Cake (TACC)” and “Hot Argument Drink (HAD)”. Dr.Milo, the owner of the shop, is an aspiring data analyst. He has collected 5 days of data. On each day, he captures the number of each product made and total kilogram of cooking gas consumed. Using all the collected data, Dr.Milo has built a linear regression model in excel, and the partial regression output is provided in Figure-2. Using this information, answer the given subquestions.

ANOVA

Figure-2: Partial Regression Output from Excel

What is the sample size for building the model in Figure-2?

Milo’s Bakery is famous for three products “BA Biscuits (BAB)”, “TA Controversy Cake (TACC)” and “Hot Argument Drink (HAD)”. Dr.Milo, the owner of the shop, is an aspiring data analyst. He has collected 5 days of data. On each day, he captures the number of each product made and total kilogram of cooking gas consumed. Using all the collected data, Dr.Milo has built a linear regression model in excel, and the partial regression output is provided in Figure-2. Using this information, answer the given subquestions.

ANOVA

Figure-2: Partial Regression Output from Excel

What is the value of Q1?

Milo’s Bakery is famous for three products “BA Biscuits (BAB)”, “TA Controversy Cake (TACC)” and “Hot Argument Drink (HAD)”. Dr.Milo, the owner of the shop, is an aspiring data analyst. He has collected 5 days of data. On each day, he captures the number of each product made and total kilogram of cooking gas consumed. Using all the collected data, Dr.Milo has built a linear regression model in excel, and the partial regression output is provided in Figure-2. Using this information, answer the given subquestions.

ANOVA

Figure-2: Partial Regression Output from Excel

What is the value of Q2? (Note: Enter your answer rounded to two decimal places. For example, if your answer is “1.235” then enter it as “1.24”)

Milo’s Bakery is famous for three products “BA Biscuits (BAB)”, “TA Controversy Cake (TACC)” and “Hot Argument Drink (HAD)”. Dr.Milo, the owner of the shop, is an aspiring data analyst. He has collected 5 days of data. On each day, he captures the number of each product made and total kilogram of cooking gas consumed. Using all the collected data, Dr.Milo has built a linear regression model in excel, and the partial regression output is provided in Figure-2. Using this information, answer the given subquestions.

ANOVA

Figure-2: Partial Regression Output from Excel

What is the value of Q3? (Note: Enter your answer rounded to two decimal places. For example, if your answer is “1.235” then enter it as “1.24”)

Milo’s Bakery is famous for three products “BA Biscuits (BAB)”, “TA Controversy Cake (TACC)” and “Hot Argument Drink (HAD)”. Dr.Milo, the owner of the shop, is an aspiring data analyst. He has collected 5 days of data. On each day, he captures the number of each product made and total kilogram of cooking gas consumed. Using all the collected data, Dr.Milo has built a linear regression model in excel, and the partial regression output is provided in Figure-2. Using this information, answer the given subquestions.

ANOVA

Figure-2: Partial Regression Output from Excel

What is the value of Q4? (Note: Enter your answer rounded to two decimal places. For example, if your answer is “1.235” then enter it as “1.24”)

Milo’s Bakery is famous for three products “BA Biscuits (BAB)”, “TA Controversy Cake (TACC)” and “Hot Argument Drink (HAD)”. Dr.Milo, the owner of the shop, is an aspiring data analyst. He has collected 5 days of data. On each day, he captures the number of each product made and total kilogram of cooking gas consumed. Using all the collected data, Dr.Milo has built a linear regression model in excel, and the partial regression output is provided in Figure-2. Using this information, answer the given subquestions.

ANOVA

Figure-2: Partial Regression Output from Excel

What is the value of Q5? (Note: Enter your answer rounded to two decimal places. For example, if your answer is “1.235” then enter it as “1.24”)

Milo’s Bakery is famous for three products “BA Biscuits (BAB)”, “TA Controversy Cake (TACC)” and “Hot Argument Drink (HAD)”. Dr.Milo, the owner of the shop, is an aspiring data analyst. He has collected 5 days of data. On each day, he captures the number of each product made and total kilogram of cooking gas consumed. Using all the collected data, Dr.Milo has built a linear regression model in excel, and the partial regression output is provided in Figure-2. Using this information, answer the given subquestions.

ANOVA

Figure-2: Partial Regression Output from Excel

At a 15% significance level, Dr. Milo thinks that the gas consumption at his company is affected by the number of BA, TACC and HAD that are made in a day. Then what do you conclude about Dr. Milo?

A matrimonial site has built a logistic classification model to predict if a person will get married or not (Married =1 and Not Married =0). The parameters used for this model are Age (in tens of years, that is, the data for a person who is “40 years old” is recorded as “4”) and Height (in feet). The built model’s coefficients are provided in Table-1. The model is being tested using matrimonial profile data available in Table-2.
Given this information, answer the given subquestions

Table-1

Table-2

At a threshold of 0.8, how many “True Positives” is the model predicting?

A matrimonial site has built a logistic classification model to predict if a person will get married or not (Married =1 and Not Married =0). The parameters used for this model are Age (in tens of years, that is, the data for a person who is “40 years old” is recorded as “4”) and Height (in feet). The built model’s coefficients are provided in Table-1. The model is being tested using matrimonial profile data available in Table-2.
Given this information, answer the given subquestions

Table-1

Table-2

At a threshold of 0.8, how many “True Negatives” is the model predicting?

A matrimonial site has built a logistic classification model to predict if a person will get married or not (Married =1 and Not Married =0). The parameters used for this model are Age (in tens of years, that is, the data for a person who is “40 years old” is recorded as “4”) and Height (in feet). The built model’s coefficients are provided in Table-1. The model is being tested using matrimonial profile data available in Table-2.
Given this information, answer the given subquestions

Table-1

Table-2

At a threshold of 0.8, how many “False Positives” is the model predicting?

A matrimonial site has built a logistic classification model to predict if a person will get married or not (Married =1 and Not Married =0). The parameters used for this model are Age (in tens of years, that is, the data for a person who is “40 years old” is recorded as “4”) and Height (in feet). The built model’s coefficients are provided in Table-1. The model is being tested using matrimonial profile data available in Table-2.
Given this information, answer the given subquestions

Table-1

Table-2

At a threshold of 0.8, how many “False Negatives” is the model predicting?

A matrimonial site has built a logistic classification model to predict if a person will get married or not (Married =1 and Not Married =0). The parameters used for this model are Age (in tens of years, that is, the data for a person who is “40 years old” is recorded as “4”) and Height (in feet). The built model’s coefficients are provided in Table-1. The model is being tested using matrimonial profile data available in Table-2.
Given this information, answer the given subquestions

Table-1

Table-2

At a threshold of 0.8, what is the ACCURACY of the model? (Note: Enter the answer in “%” rounded to two decimal places without the “%” symbol. For example, if the answer is “1.234%”, then enter it as “1.23”)

A matrimonial site has built a logistic classification model to predict if a person will get married or not (Married =1 and Not Married =0). The parameters used for this model are Age (in tens of years, that is, the data for a person who is “40 years old” is recorded as “4”) and Height (in feet). The built model’s coefficients are provided in Table-1. The model is being tested using matrimonial profile data available in Table-2.
Given this information, answer the given subquestions

Table-1

Table-2

At a threshold of 0.8, what is the PRECISION of the model for predicting the Negative Class? (Note: Enter the answer in “%” rounded to two decimal places without the “%” symbol. For example, if the answer is “1.234%”, then enter it as “1.23”)

A matrimonial site has built a logistic classification model to predict if a person will get married or not (Married =1 and Not Married =0). The parameters used for this model are Age (in tens of years, that is, the data for a person who is “40 years old” is recorded as “4”) and Height (in feet). The built model’s coefficients are provided in Table-1. The model is being tested using matrimonial profile data available in Table-2.
Given this information, answer the given subquestions

Table-1

Table-2

At a threshold of 0.8, what is the RECALL of the model for predicting the Positive Class? (Note: Enter the answer in “%” rounded to two decimal places without the “%” symbol. For example, if the answer is “1.234%”, then enter it as “1.23”)

A demand response curve has a constant price elasticity of +0.6. If the price of the product is 100 and the corresponding demand is 200, then answer the given subquestions.

What is the value of “Constant” (“C”) for the constant elasticity model? (Note: Enter the answer rounded to two decimal places. For example, if the answer is “1.234”, then enter it as “1.23”)

A demand response curve has a constant price elasticity of +0.6. If the price of the product is 100 and the corresponding demand is 200, then answer the given subquestions.

What should be the price to achieve a demand of 300? (Note: Enter the answer rounded to two decimal places. For example, if the answer is “1.234”, then enter it as “1.23”)