[SOLVED] PROJECT ASSIGNMENT #2 – USING SPREADSHEET DATA TO CREATE CHARTS/GRAPHS

PROJECT ASSIGNMENT #2 – USING SPREADSHEET DATA TO CREATE CHARTS/GRAPHS

Step by Step Instructions:

Using Google Sheets’ chart-creating feature, you will create five separate graphs showing the relationship between the following grouped pairs.

1. Nominal GDP and Real GDP (line chart)
2. Nominal GDP Growth Rate and Real GDP Growth Rate (column chart)
3. Real GDP Growth Rate and RGDP per capita Growth Rate (column chart)
4. Real GDP per capita Growth Rate and Unemployment rate (column chart)
5. RGDP per capita Growth Rate and Inflation Rate (line chart)

Before you begin:

• Check your Assignment #1 grade in the If you did not make a 100 on your spreadsheet, you had calculation or formatting mistakes that need correcting before you begin this assignment. You can view the feedback to see what you need to correct before starting this assignment.
• You will use your spreadsheet for this Open the spreadsheet and replace the XXX on the 1980 row with the following values and then convert them to percentages.
  • Nominal GDP growth rate .0875
  • GDP deflator % change .0905
  • Real GDP growth rate -.0027
  • Population growth rate .0116
  • Real GDP per capita growth rate -.0142
  • Inflation rate .1350

• Before creating your first graph, name the data At the bottom of your spreadsheet on the tab labeled Sheet1, open the drop-down menu and click on Rename. Name this tab “Macro Data”.

Step 1: Create a Graph

There is a video demonstrating how to create Graph #2. These instructions will guide you through creating Graph #1.

• To create a graph/chart, you will select the data to be graphed by dragging your mouse through the entire column (including titles) of the desired data (highlight the Nominal GDP column, including the column title).
• Once the entire column is highlighted, go to the Google Sheet menu at the top and find the Insert Chart icon and click on A graph will immediately appear on the page.
• Your data for Chart 1 should show up as a line If it isn’t, from the Chart Type menu in the Chart editor, choose one of the Line charts.

Step 2: Add Another Series

• To add the rest of the data to your chart, in the Chart editor menu, find and click on Add Series (near the bottom of the menu). Click on the grid-looking box (windowpane).
• Highlight the data to This will automatically fill in and populate your chart (highlight the entire Real GDP column, including the title).
• Check to verify that a key has been generated at the If there isn’t one, at the bottom of

the Chart Editor menu, check the box “Use row 4 as header”, making sure the

• If that did not add a key, you didn’t highlight the title when choosing the In that case, delete the data set from your graph and begin again.

• Note: If the Chart Editor isn’t open, click on the graph, then click on the three dots in the upper right-hand corner and choose Edit chart.

Step 3: Add the X-Axis

• In the Chart editor menu, under X axis choose Add X-axis. Click on the grid-looking box (windowpane).
• In the Years column, highlight the Years column (include the title). That range automatically pops up and is added to the graph.
• Before moving on to the next step make sure the boxes at the bottom that say, “Use row 4 as headers” and “Use column A as labels” are checked and “Treat labels as text” is NOT

Step 4: Add Detail

• You will continue to edit the chart by adding In the menu above your chart, in your Chart Editor, at the top, choose Customize.
• In the drop-down menu, click on Chart & axis titles.
• In the box below, make sure it says Chart title, then under Title text, type in the title of your This needs to reflect the information you are graphing. For example, Chart 1 title will be Nominal and Real GDP.
  • Next, click in the Chart title box and choose the Horizontal axis title, in the box below, type in YEARS.
  • Click on the Chart title box again and choose Vertical axis title, in the box below, type in whatever unit is being This must be in the unit the variable is measured.