For Assignment One, you will analyze a data set which relates to the performance of an engineering enterprise/ or
business firm. Using the data you collect, you will use a statistical model of your choice to find the predicted value of
your dependent variable Yi. You will need to use the tools available in Microsoft Excel to analyze the data, and
present it in the form of a report. Your report will include four parts:
In Part 1, you will collect data from a company of your choice, then briefly summarize the types of real data
collected and analyze its comprehensiveness. More comprehensive data iare expected for higher marks.
In Part 2, you need to further analyze the data by constructing a stem and leaf plot and a box plot.
In Part 3, you need to use the appropriate statistical modeling techniques (Regression or Discriminant Analysis) to
find the relationship between the data (variables).
In Part 4, Use the data you collected to build a forecasting model using Microsoft Excel, and apply a suitable
quantitative forecasting technique to make a set of predictions for the next 10 years. Determine the value of M.S.E.
(Mean Squared Error).
This assignment will include two components – a word file for the report, and an excel file.