Assignment: Demand Estimation and Forecasting $-$

Trend Line and Regression Analysis

Objective: Find out the Trend line for the Sales Turnover of Adani Power Electricity for last $10$ years period.

Model: Sales Turnover Year $(x))$

Sales Turnover $(Y)=$ Dependent Variable

Year $(x)=$ Independent Variable

QCalculate or estimate $\text{'}$a or $\text{'}$ and $\text{'}b$ or $\text{'}.$

Dinterpret $\text{'}$a or $\text{'}$ and $\text{'}b$ or $\text{'}.$

DForecast Sales Turnover $($ Y $)$ for years $2025$ and $2026.$

Assignment: Guidelines

Data Collection, Analysis, and Presentation

$$ Students are required to collect sales turnover data for an assigned public

listed company $($NSE$/$BSE$)$ spanning the past ten years.

$$ The collected data should be subjected to regression and trend analysis using

Microsoft Excel.

$$ The final submission should comprise a PowerPoint presentation

incorporating the Excel spreadsheet as an embedded object.

$$ Students are expected to meticulously follow the provided solved examples,

particularly emphasizing the outcomes of Example No$.2.$

Note: The data for sales turnover can be sourced from the respective company's Adani Power Electricity website. Data Collection, Analysis, and Presentation

Students are required to collect sales turnover data for an assigned public

listed company $($NSE$/$BSE$)$ spanning the past ten years.

The collected data should be subjected to regression and trend analysis using

Microsoft Excel.

The final submission should comprise a PowerPoint presentation

incorporating the Excel spreadsheet as an embedded object.

Students are expected to meticulously follow the provided solved examples,

particularly emphasizing the outcomes of Example No$.2.$

Note: The data for sales turnover can be sourced from the respective company's

website.

$($Also I have an PDF file how can I send you $)$