Correlation

Use the Remington’s Data Set and reply to the following:

Fundamentals of Correlation
Follow the steps in worksheet RQ5 Online of the Remington’s Data Set using Excel.
Calculate the correlation coefficient (r) for Has competent employees, as the independent variable, and Satisfaction with Remington’s, as the dependent variable.
Create a Word document in which you do the following:
Describe the steps for calculating r in Excel.
Describe the strength of r, the direction of r, and exactly what r tells you about the relationship between Has competent employees and Satisfaction.
Fundamentals of Correlation
Follow the steps in worksheet RQ5 Online of the Remington’s Data Set using Excel.
Calculate and interpret the coefficient of determination r2 for Has competent employees, as the independent variable, and Satisfaction with Remington’s, as the dependent variable.
Add the following explanation to your Word document: Describe the steps for calculating r2 in Excel and exactly what r2 tells you in terms of the impact Has competent employees has on Satisfaction.
Submit no more than 2 total documents, one Excel document and one Word document

Sample Solution

Twimble declared Finch as his decision to head the sorting room, anyway the book cautions not to remain in the sorting room excessively long. Finch suggests Frump for the advancement rather than himself, to benefit the organization. Twimble is hesitant to advance Frump due to his sluggishness, however Frump vows to be a decent worker (“The Company Way (Reprise)”). Twimble and Bratt are both dazzled by Finch’s sacrificial choice, and Bratt extends to him an employment opportunity as a lesser official in the Plans and Systems division, headed by Mr. Gatch, unfortunately.

An incredibly alluring yet air-headed lady named Hedy LaRue, Mr. Biggley’s mystery paramour, is contracted as a secretary. Her passage draws in the consideration of the considerable number of men in the workplace, provoking Bratt to clarify the workplace approach on being a tease (“A Secretary isn’t a Toy”). Finch gains from Mr. Biggley’s secretary, Miss Jones, that Biggley is a glad alumni of Old Ivy school. In the lift by the day’s end, Rosemary’s kindred secretary Smitty causes her and Finch set up a date (“Been A Long Day”). After they leave, Frump runs into Biggley and Hedy and understands the idea of their relationship. He extorts Biggley into giving him an advancement, by taking steps to tell his mom (“Been A Long Day (Reprise)”).

Finch shows up sooner than expected Saturday morning and sets up the workplace so it would appear that he has been working throughout the night, realizing that Biggley is coming in to the workplace soon. Finch persuades Biggley that he is likewise a glad former student of Old Ivy and they sing the Old Ivy battle melody (“Grand Old Ivy”). Biggley requests that Finch be given his own office and secretary, and Bratt doles out Hedy to him. With the book’s assistance, Finch understands that Biggley must be Hedy’s supporter and sends her on a task to Gatch, very much aware that Gatch will make a go at her. Gatch succumbs to the snare and is sent to Venezuela, and Finch is elevated to his situation as head of Plans and Systems.

At a gathering for the new Advertising Department head, Benjamin Burton Daniel Ovington, Rosemary would like to dazzle Finch with her new dress, a Paris unique. In any case, the various ladies land at the gathering wearing a similar dress (“Paris Original”). Hedy, who has had an excessive amount to drink, goes up to Biggley’s office to shower. Slob plans for Biggley to discover Finch kissing Hedy in his office, however after LaRue coerces Finch into kissing her, he understands he’s entirely love with Rosemary and proposes to her (“Rosemary”). As Rosemary is going to acknowledge, Hedy leaves the washroom in a towel which maddens Rosemary. She leaves, however comes back to disclose to Finch that Bud and Biggley are simply outside. Slob and Big