1.Nemi Mehta is owning 50 Hectares of land near Junagadh. On his Farm, he cultivates
Giloy, which is a medicinal plant in Ayurveda. The below-given table shows the sales
of ‘Giloy Vati’ that his team is preparing as per one Ayurveda script (book), and the
amount they spend on the Advertisement of it.

Nemi’s problem is to analyze the effect of Advertisement on sales. Firstly, He wants to
understand the presence of a linear relationship between the sales and ‘amount spent in
advertisement’. He also wants to run a correlation and regression to know whether he
should keep spending money on Advertisements or not. If sales figures are not affected
by advertisement, he should not spend money on it.
So, take the EXCEL output of the following and write the interpretation.
 Appropriate type of Graph which can exhibit the linear relation b/w variables.
 Karl Pearson’s Correlation Coefficient
 Regression Analysis
 Graph that shows predicted v/s actual sales figures.

2. The table given below is the ‘single year age population’ (taken from census 2011).
This table shows the population of people (age-wise) living in Leh at the time of the
census 2011 survey. Transform this ungrouped data into Grouped data by forming age
groups (only five age groups), and then find out Mean, Variance, Standard deviation,
Ogive, and Histogram. Write the summary based on your calculations.

3.a. The given table shows the rainfall of Gujarat Region. Forecast the rainfall using
Exponential Smoothing. Use Alpha =0.2, 0.5 and 0.8. Data is available from 1997 to
2016, use this series for the calculation and forecast the rainfall for the year 2017. To
know, what extent the prediction is correct, actual rainfall for 2017 .

millimeters) is provided. Based on MSE and MAD, find out which alpha values
among the three suggestions are relatively near to actual value?

3.b. A new gas-electric hybrid car has recently hit the market. The distance traveled on
1 gallon of fuel is normally distributed with a mean of 65 miles and a standard
deviation of 4 miles. Find the probability of the following events. (show the
concerned region by z curve)
1. The car travels more than 70 miles per gallon.
2. The car travels less than 60 miles per gallon.
3. The car travels between 55 and 70 miles per gallon.