In order to prepare a reply to Carolyn’s email, you will need to examine and analyse the dataset, Hyperstar2.xls, thoroughly. The following are some guidelines to follow.
there are 4 tasks in this assignment.
Task One – Factors influencing Gross Profit.
Task Two – Development of a multiple regression model.(Minimum requirements for the final model:
At least two independent variables
One categorical independent variable)
Task Three – Time Series analysis.
Task Four – Critique the Business Research Approach.(note:that no actual analysis is required for this task.)
PS:The assignment consists of two parts: Analysis and Report.
You are required on both written report (approx. 2000 words) and analysis (in Excel-IMPORTANT).
Analysis
The analysis should be in the appropriate worksheets in the Excel file. Each step in the model building for task two should be included in the tabs Q2-Correlation, Q2-1, Q2-2, etc. If you need more worksheets then add them. Further instructions are included at the top of each worksheet.
Before submitting your analysis make sure it is logically organised and any incorrect or unnecessary output has been removed.
Report
The report should be written for an audience that has no, or minimal, business analytics background. You should avoid the use of technical terms. The one exception may be in task 2 as you may want to include the actual regression model in the report. You are required to describe all five tasks. It is up to you how to structure and format the final report.
