Homework answers / question archive / please refer to this google drive link for the question (word document) and the excel sheet to answer the questions; https://drive

please refer to this google drive link for the question (word document) and the excel sheet to answer the questions; https://drive

Math

Share With

please refer to this google drive link for the question (word document)

and the excel sheet to answer the questions;
https://drive.google.com/drive/folders/1cFCu86WgvUG55ZZzKIJj8d4gl2KVXSn6?usp=sharing
(please go to the google drive link for the full question and the excel file to answer the questions)
You are Tank McTavish, an analyst often asked for by media outlets and journalists to assist in giving their stories more credence. That is, they believe your numerical perceptiveness gives their stories greater rigour. You work for the firm "Media Analytical Insight (MAI)"1 in their analysis department. A large Australian news media group has requested information for two stories they wish to run. One regarding the salaries of Australian University Vice Chancellors, and the other regarding climate change and its effect on a changing sea level. You have been forwarded an email from Dr Tiny Numbaz, asking you to perform some specific data analysis. The email making this request alongside some guidelines (in blue) is presented below. Consider all comments carefully
To:                  Tank McTavish
From:               Dr Tiny Numbaz - Chief Liaison Officer 
Subject:            Data Analysis 
Dear Tank,
Some of our senior reporters are awaiting summary reports and information on the following projects:
1.    Project 1: University Vice Chancellor Salaries
Universities around the world help interested students find the true meaning of things. Universities are renowned knowledge generators, and they help societies evolve by assisting in the challenges that people face. Universities reward their Vice Chancellors (the Universities CEO) as a consequence of many things, including the university's success. 
We have been provided with a data set that includes the salary for 37 Vice Chancellors from universities across Australia. Build a multiple regression model to predict the salary of a Vice Chancellor. Your model should provide insights into which of the factors influence a Vice Chancello'rs salary, as well as the ability to predict salary for various scenarios. 
For this analysis, you will need to build a multiple regression model using Sal($'000) as the dependent variable, and all other measures included in the data set as possible predictors. You should follow the model building process introduced in the lecture and seminars. You should also carefully consider the following: 
(a)  Transform the categorical measure into a suitable dummy variable.  
(b)  Generate relevant model summary information.  
(c)   Build a multiple regression model and assess the model for overall significance (F test with alpha set at 0.05).  
(d)  In the next step(s), if the overall model is found to be significant, in a stepwise fashion, sequentially (one at a time) remove the variables that are least likely to be contributing to any significant change in the dependent variable. You will need to conduct t-tests with alpha set at 0.05 to determine the significance of the various independent variables you exclude and include in your model.
(e) Once you have created a multiple regression model, where all of the included independent measures are contributing significantly to a change in salary, ensure that you can use the regression model to provide salary estimates for any scenario regarding your included set of independent measures
1.    Project 2: The Global Mean Sea Level 
Climate change is of global interest, particulary in costal areas where there are relatively higher densities of people. That the climate is changing is undeniable, however, a great deal of debate continues regarding the underlying causes of climate change. 
Data collected on the Global Mean Sea Level (mm) is recorded on the spread sheet "Time series data". One hundred and thirty three (133) data points have been recorded covering the period from 1880 through to and including 2013. We are interested to better understand the mean sea level. Is it changing? If so, in what way? How fast is it changing? We want to forecast both the proportional change that might be expected at some time in the future, as well as the magnitude of that change.
Implement a proper forecasting model to address this request and provide your interpretation. 
For this investigation, you will need to consider several forecasting models and evaluate their performance in terms of forecasting accuracy and model fit. You should consider the following:
(a)  Both 3 and 5 year centred moving average models.
(b)  Fitting linear, exponential, and polynomial (order 2), trend lines to the original data.
(c)   What do the errors say about the usefulness of the forecasting models?
(d)  What are the R2 values of the various models you have fitted?
(e)  Using each of the models you have built, develop a forecast model for the Global Mean Sea Level change that can be used to forecast any time period.
I look forward to your response.
Sincerely 
Assignment instructions
In order to write a reply to Dr Tiny Numbaz email, you will need to thoroughly examine and analyse the datasets. The Excel file in the onedrive includes a sheet named "Variable Definitions" describing all of the variables used in other worksheets. The following provides some guidelines that will help you to write a reply to Dr Tiny Numbaz and answer the online test. 
please refer to this google drive link for the question (word document) and the excel sheet to answer the questions;
https://drive.google.com/drive/folders/1cFCu86WgvUG55ZZzKIJj8d4gl2KVXSn6?usp=sharing