Resave your Excel file. Add a new sheet to the file. Build the model shown in the previous video. DON'T FORGET THE DOLLAR SIGNS!

Type the answers to the questions listed below under that model in the same Excel sheet.

Resave the file. Upload it to Canvas for activity #$7.$

Questions:

If Tom makes $$75$ an hour, has a job level of $6,$ and it has been $5$ years since he was last promoted, what is his predicted job satisfaction rating $($show your work in your answer to this question$).$

If Jane makes $$25$ an hour, has a job level of $3,$ and it has been $1$ year since she was last promoted, what is her predicted job satisfaction rating $($show your work in your answer to this question$).$

Using your own experience, what other factors might affect job satisfaction? Describeusing a full sentence for each $-$ three additional factors that you believe might affect a person's job satisfaction.

If you were a consultant that had just performed this regression analysis for this employer, what advice would you give to this employer when you presented the outcome of this analysis? Provide at least two suggestions in complete sentences.