Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am not sure what to do? Help please Module Two Data Set file with the completed visualizations. Include both charts and calculated outcomes on

I am not sure what to do? Help please

Module Two Data Set file with the completed visualizations. Include both charts and calculated outcomes on the Edgard Grades tab within the Excel file next to the data set.

Directions

Follow the steps for the scenario from your textbook, linked in the Supporting Materials section, to complete this assignment.

Use the Module Two Data Set, linked in the Supporting Materials section, to correctly customize data visualizations targeted for the scenario. This assignment uses a complete/incomplete rubric. If your data visualizations do not match the two contained within the textbook, course GPA and total number of each grade earned, rework the steps until you reach the correct data visualizations. You will also need to accurately calculate specific outcomes related to Edgards grades.

Specifically, you must address the following rubric criteria:

  1. Create an accurate line chart for Edgards course GPA with all 16 data points. Include the following detail in your response:
    1. Title of chart as it is in the textbook
  2. Create an accurate column chart for the total number of each grade earned for Edgard. Include the following detail in your response:
    1. Title of chart as it is in the textbook
  3. Calculate each outcome accurately using Excel functions. Include the following details in your response:
    1. Overall GPA for three semesters
    2. Median (midpoint) of Edgards GPA
    3. Mode (most frequently occurring) of the course GPA earned

What to Submit

Submit the Module Two Data Set file with the completed visualizations. Include both charts and calculated outcomes on the Edgard Grades tab within the Excel file next to the data set.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools for business decision making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

6th Edition

978-1119191674, 047053477X, 111919167X, 978-0470534779

More Books

Students also viewed these Accounting questions