Explore BrainMass
Share

Creating Line Chart Interpretations

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Cal Rubine, chair of the Theatre Arts Division at Niagara Peninsula College, has asked you to create charts from the grades analysis report to present at a divisional meeting. After reviewing the grades, you decide to create a line chart depicting the grades for all of the courses and a pie chart summarizing the total grades.
1. Create a line chart in its own sheet that will display the A+ through F grades for each course. Include an appropriate chart title. You determine what other chart elements to include that will make the chart easy to interpret.
2. Create a 3-d pie chart that will display the total of each grade as a percentage of 100. (Hint: Select the ranges B4:G4 and B12:G12 before starting the Chart Wizard.) Include an appropriate chart title. Place the pie at the bottom of the Grades worksheet starting in Row 14.
3. Resize the chart to extend its width to the right edge of column H and the height to the bottom boundary of row 30.
4. Draw an arrow pointing to the F slice in the pie chart. Create a text box at the end of the arrow containing the text Lowest attrition since 1997!
5. If necessary, resize the arrow and text box.
6. Changes the font color of the text inside the text box to Red.
7. Change the line color of the border of the text box to Blue.

© BrainMass Inc. brainmass.com October 24, 2018, 7:01 pm ad1c9bdddf
https://brainmass.com/computer-science/software-development/creating-line-chart-interpretations-55640

Attachments

Solution Summary

The expert creates line chart interpretations.

$2.19
See Also This Related BrainMass Solution

Regression Analysis

*****I need helllllllp.

Attach is the data key, the data tool and the template.
It has to be Original not copied because they change the data numbers each session so whatever is in the library will not work for this assignment.

***** I will need help with the Interpretation of the numbers and the conclusion. How can I do an interpretaion of the numbers if I don't under the number. I am not asking you to do the paper I can word the interpration to fit my text book but i have to have some understanding on the numbers that are being analysis. Therefore i need help with the WHOLE paper not just part of it.

TEST #1: Regression Analysis- Benefits & Intrinsic

Perform the following Regression Analysis, using a .05 significance level

ââ?¬¢Run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable.
ââ?"¦Copy and paste the results of the output to your report in Microsoft Word.
ââ?¬¢Create a graph with the trendline displayed the 3 regression.
ââ?"¦Copy and paste the results of the output to your report in Microsoft Word.

TEST #2: Regression Analysis- Benefits & Extrinsic

Perform the following Regression Analysis, using a .05 significance level

ââ?¬¢Run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the EXTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable.
ââ?"¦Copy and paste the results of the output to your report in Microsoft Word.
ââ?¬¢Create a graph with the trendline displayed for the regression.
ââ?"¦Copy and paste the results of the output to your report in Microsoft Word.
TEST #3: Regression Analysis- Benefits & Overall Job Satisfaction

Perform the following Regression Analysis, using a .05 significance level

ââ?¬¢Run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the OVERALL job satisfaction column of all data points in the AIU data set as the dependent variable.
ââ?"¦Copy and paste the results of the output to your report in Microsoft Word.
ââ?¬¢Create a graph with the trendline displayed for the regression.
ââ?"¦Copy and paste the results of the output to your report in Microsoft Word.
Overview of the Regressions

Complete the table with the following information:

Dependent Variable Slope Y-intercept

Equation

Intrinsic

Extrinsic

Overall

ââ?¬¢State the slope and the y-intercept for the three regressions.
ââ?¬¢State the least squares regression line equations for the threes regressions.
ââ?¬¢State the R-squared value for each of the regressions.
Analysis of the Regressions

Make very specific comments and give reasons regarding any similarities or differences in the output results.

Which regression produces the strongest correlation coefficient result? Why? What does it mean to a manager?

View Full Posting Details