My Blog

Category: Business & Finance > Marketing

  • [Solved] tutor

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering tutor.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] TUTOR

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering TUTOR.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] tutor

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering tutor.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] MKTG201

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    see attached – ## WK5Instructions_MKTG201.docx **## WK5Instructions_MKTG201.docx** **Instructions: EOS Brand** **Assignment Directions:** **Objective:** For this assignment, you will explore how brands implement Integrated Marketing Communications (IMC) by evaluating their ability to deliver a con…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    see attached

    – ## WK5Instructions_MKTG201.docx

    **## WK5Instructions_MKTG201.docx**

    **Instructions: EOS Brand**

    **Assignment Directions:**

    **Objective:**

    For this assignment, you will explore how brands implement Integrated Marketing Communications (IMC) by evaluating their ability to deliver a consistent message across various marketing channels. Start by selecting a brand that interests you; this can be a well-known company or a brand you are familiar with. Your task is to review the brand’s IMC program comprehensively. Begin your report with an introduction where you present the chosen brand and provide a brief overview of its IMC strategy. Follow this with a detailed analysis, addressing each key aspect of the brand’s IMC approach, and use specific examples to support your observations. Conclude your report by summarizing the effectiveness of the brand’s integration of marketing messages across different platforms and discuss the advantages of their approach.

    **Instructions:**

    1.    Select a Brand: Choose a brand that interests you. This can be a well-known company or a brand you are familiar with.

    2.    Review the Brand’s IMC Program: Your analysis should cover the following areas:

    ·  Social Media Platforms:

    ·     Review the brand’s social media accounts (e.g., Facebook, Instagram, YouTube).

    ·     Are the messaging and ads consistent across these platforms?

    ·     Does the brand use any influencers? If so, how are they integrated into the brand’s messaging?

    ·  Website Review:

    ·     Visit the brand’s official website.

    ·     Evaluate how the website’s design, content, and messaging align with what you observed on their social media platforms.

    · Traditional Marketing:

    ·     Check if the brand uses traditional marketing methods such as billboards, TV commercials, or print ads.

    ·     Analyze whether these traditional marketing efforts are consistent with their online presence.

    3.   Evaluate Consistency Across Platforms:

    · Consistency: Assess how well the brand maintains a consistent look, tone, and key message across all marketing platforms (social media, website, traditional marketing).

    · Effectiveness: Consider how this consistency impacts the brand’s overall image and customer perception.

    **Guidelines to help you write your paper:**

    · Introduction: Introduce the brand you have selected and briefly describe its IMC approach.

    · Analysis: Address each of the areas mentioned above. Use specific examples to illustrate your observations. Use clear headings for each section.

    · Conclusion: Summarize how effectively the brand integrates its marketing messages across different platforms and the benefits of this approach.

    **Submission Instructions:**

    · Please use: APA formatting using a cover page, 1-2 content page(s) and Reference page. Word document. You must cite at least 2 references.

    · Cover page

    · Content page

    · Content page

    · Content page (optional)

    · Content page (optional

    · References

    **## WK5Instructions_MKTG201.docx**

    **Instructions: EOS Brand**

    **Assignment Directions:**

    **Objective:**

    For this assignment, you will explore how brands implement Integrated Marketing Communications (IMC) by evaluating their ability to deliver a consistent message across various marketing channels. Start by selecting a brand that interests you; this can be a well-known company or a brand you are familiar with. Your task is to review the brand’s IMC program comprehensively. Begin your report with an introduction where you present the chosen brand and provide a brief overview of its IMC strategy. Follow this with a detailed analysis, addressing each key aspect of the brand’s IMC approach, and use specific examples to support your observations. Conclude your report by summarizing the effectiveness of the brand’s integration of marketing messages across different platforms and discuss the advantages of their approach.

    **Instructions:**

    1.    Select a Brand: Choose a brand that interests you. This can be a well-known company or a brand you are familiar with.

    2.    Review the Brand’s IMC Program: Your analysis should cover the following areas:

    ·  Social Media Platforms:

    ·     Review the brand’s social media accounts (e.g., Facebook, Instagram, YouTube).

    ·     Are the messaging and ads consistent across these platforms?

    ·     Does the brand use any influencers? If so, how are they integrated into the brand’s messaging?

    ·  Website Review:

    ·     Visit the brand’s official website.

    ·     Evaluate how the website’s design, content, and messaging align with what you observed on their social media platforms.

    · Traditional Marketing:

    ·     Check if the brand uses traditional marketing methods such as billboards, TV commercials, or print ads.

    ·     Analyze whether these traditional marketing efforts are consistent with their online presence.

    3.   Evaluate Consistency Across Platforms:

    · Consistency: Assess how well the brand maintains a consistent look, tone, and key message across all marketing platforms (social media, website, traditional marketing).

    · Effectiveness: Consider how this consistency impacts the brand’s overall image and customer perception.

    **Guidelines to help you write your paper:**

    · Introduction: Introduce the brand you have selected and briefly describe its IMC approach.

    · Analysis: Address each of the areas mentioned above. Use specific examples to illustrate your observations. Use clear headings for each section.

    · Conclusion: Summarize how effectively the brand integrates its marketing messages across different platforms and the benefits of this approach.

    **Submission Instructions:**

    · Please use: APA formatting using a cover page, 1-2 content page(s) and Reference page. Word document. You must cite at least 2 references.

    · Cover page

    · Content page

    · Content page

    · Content page (optional)

    · Content page (optional

    · References

  • [Solved] MKTG201

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    see attached – ## Example_StudentPaperTemplateAPA7th.docx – ## WK2Instructions_MKTG201.docx **## Example_StudentPaperTemplateAPA7th.docx** | | | | — | — | | Running head: GUIDED IMAGERY AND PROGRESSIVE MUSCLE RELAXATION | 2 | 1 **Title of Paper in Bold Centered** Student Name American Public …

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    see attached

    – ## Example_StudentPaperTemplateAPA7th.docx

    – ## WK2Instructions_MKTG201.docx

    **## Example_StudentPaperTemplateAPA7th.docx**

    | | |
    | — | — |
    | Running head: GUIDED IMAGERY AND PROGRESSIVE MUSCLE RELAXATION | 2 |

    1

    **Title of Paper in Bold Centered**

    Student Name

    American Public University

    COURSE####: Course Title

    Instructor Name

    Due Date

    **Repeat the Title – Level 1 Header**

    Hit the tab key one time to begin the main body of the paper. The paragraphs of the main document are indented. The computer will wrap your text for you based upon the margin settings established by this document template. It is not necessary for you to hit the Enter or return key at the end of a line of text. Only hit the enter key (one time) when you reach the end of a paragraph.

    Then hit the tab key to indent and then continue typing the paper. In APA any source that you use in your paper must have an in-text citation. In APA these citations include the author’s last name and the year of the publication in parentheses (Name, Year).

    **Level 2 Header use: Flush Left, Bold, Title Case Heading**

    Sub-section your essay using sub-headers in the same sequence you introduced your topic in your lead paragraph, your thesis.

    **_Level 3 Header use: Flush Left, Bold Italic, Title Case Heading_**

    The more lengthy or complex your essay, the potential for using additional Level Headers; notice the subtle difference. One tip for any submission, always double-check the font choice is consistent throughout the essay.

    **Conclusion – Level 1 Header**

    Begin to summarize the main points of your topic in three to five sentences. The conclusion of your paper should re-phrase the points of what your reader should be left remembering, nothing new, concise and to the point.

    **References – Level 1 Header**

    Lastname, C. (2008). Title of the source without caps except Proper Nouns or: First word after colon.
    _The Journal or Publication Italicized and Capped_, Vol#(Issue#), Page numbers.

    SEE APA GUIDELINES FOR PROPER CITATION OF DIFFERENT TYPES OF SOURCES.

    **## WK2Instructions_MKTG201.docx**

    **Instructions**

    **Assignment Directions:**

    Objective: The goal of this assignment is to help you understand and apply the concept of market segmentation by analyzing the target market characteristics of a brand of your choice.

    When creating a target market profile, a common mistake is making it too broad—trying to include everyone instead of focusing on a specific group. Yes, big brands like Nike or Apple serve multiple audiences, but for this assignment, that’s not what we’re asking you to do. We want you to create one clear, highly detailed profile of a single target audience—just like a real marketer would when crafting a campaign. Think about who they are, what they care about, and why they buy. The more specific, the better. A well-defined target market doesn’t exclude anyone else from buying your product; it just sharpens the focus on who you’re trying to reach for specific campaigns. In reality, big companies have multiple target audience profiles, but for this assignment, we’re asking you to develop
    just one potential market segment. This is important because professional marketers need to identify advertising and promotional outlets that align with a specific target audience—and if the profile is too broad, that becomes nearly impossible.

    Use at least 2 market research resources to help you gather information and fill out the chart below.

    **Instructions:**

    1. Select a Brand: Choose a brand from one of the following categories:

    · Food brand
    **Cambell’s Soup**

    · Clothing company

    · Technology company

    · Automobile company

    · Airline company

    2. Describe the Brand: Write a 1–2 paragraph description of your chosen brand. Highlight its products or services, key history or milestones, and any unique qualities that make it stand out in the market.

    3. Complete the Chart: Create a chart in Word or Excel similar to the one below to identify and describe the market segmentation characteristics of the chosen brand. Fill in each section with relevant information based on your analysis of the brand’s target market. Use market research.

    | | |
    | — | — |
    | Segmentation Type | Enter Your Brand Name Here |
    | Demographics | |
    | Psychographics | |
    | Geographics | |
    | Behavioral Characteristics | |

    4. Conduct a Brief Analysis: Write a brief analysis explaining how the identified characteristics of the target market can influence the brand’s marketing strategy.

    **Submission Instructions:**

    · Please use: APA formatting using a cover page, 1-2 content page(s) and reference page. Word document. Include the above chart for your chosen brand in your paper.

    · Cover page

    · Content page

    · Content page

    · References

    **## WK2Instructions_MKTG201.docx**

    **Instructions**

    **Assignment Directions:**

    Objective: The goal of this assignment is to help you understand and apply the concept of market segmentation by analyzing the target market characteristics of a brand of your choice.

    When creating a target market profile, a common mistake is making it too broad—trying to include everyone instead of focusing on a specific group. Yes, big brands like Nike or Apple serve multiple audiences, but for this assignment, that’s not what we’re asking you to do. We want you to create one clear, highly detailed profile of a single target audience—just like a real marketer would when crafting a campaign. Think about who they are, what they care about, and why they buy. The more specific, the better. A well-defined target market doesn’t exclude anyone else from buying your product; it just sharpens the focus on who you’re trying to reach for specific campaigns. In reality, big companies have multiple target audience profiles, but for this assignment, we’re asking you to develop
    just one potential market segment. This is important because professional marketers need to identify advertising and promotional outlets that align with a specific target audience—and if the profile is too broad, that becomes nearly impossible.

    Use at least 2 market research resources to help you gather information and fill out the chart below.

    **Instructions:**

    1. Select a Brand: Choose a brand from one of the following categories:

    · Food brand
    **Cambell’s Soup**

    · Clothing company

    · Technology company

    · Automobile company

    · Airline company

    2. Describe the Brand: Write a 1–2 paragraph description of your chosen brand. Highlight its products or services, key history or milestones, and any unique qualities that make it stand out in the market.

    3. Complete the Chart: Create a chart in Word or Excel similar to the one below to identify and describe the market segmentation characteristics of the chosen brand. Fill in each section with relevant information based on your analysis of the brand’s target market. Use market research.

    | | |
    | — | — |
    | Segmentation Type | Enter Your Brand Name Here |
    | Demographics | |
    | Psychographics | |
    | Geographics | |
    | Behavioral Characteristics | |

    4. Conduct a Brief Analysis: Write a brief analysis explaining how the identified characteristics of the target market can influence the brand’s marketing strategy.

    **Submission Instructions:**

    · Please use: APA formatting using a cover page, 1-2 content page(s) and reference page. Word document. Include the above chart for your chosen brand in your paper.

    · Cover page

    · Content page

    · Content page

    · References

    **## Example_StudentPaperTemplateAPA7th.docx**

    | | |
    | — | — |
    | Running head: GUIDED IMAGERY AND PROGRESSIVE MUSCLE RELAXATION | 2 |

    1

    **Title of Paper in Bold Centered**

    Student Name

    American Public University

    COURSE####: Course Title

    Instructor Name

    Due Date

    **Repeat the Title – Level 1 Header**

    Hit the tab key one time to begin the main body of the paper. The paragraphs of the main document are indented. The computer will wrap your text for you based upon the margin settings established by this document template. It is not necessary for you to hit the Enter or return key at the end of a line of text. Only hit the enter key (one time) when you reach the end of a paragraph.

    Then hit the tab key to indent and then continue typing the paper. In APA any source that you use in your paper must have an in-text citation. In APA these citations include the author’s last name and the year of the publication in parentheses (Name, Year).

    **Level 2 Header use: Flush Left, Bold, Title Case Heading**

    Sub-section your essay using sub-headers in the same sequence you introduced your topic in your lead paragraph, your thesis.

    **_Level 3 Header use: Flush Left, Bold Italic, Title Case Heading_**

    The more lengthy or complex your essay, the potential for using additional Level Headers; notice the subtle difference. One tip for any submission, always double-check the font choice is consistent throughout the essay.

    **Conclusion – Level 1 Header**

    Begin to summarize the main points of your topic in three to five sentences. The conclusion of your paper should re-phrase the points of what your reader should be left remembering, nothing new, concise and to the point.

    **References – Level 1 Header**

    Lastname, C. (2008). Title of the source without caps except Proper Nouns or: First word after colon.
    _The Journal or Publication Italicized and Capped_, Vol#(Issue#), Page numbers.

    SEE APA GUIDELINES FOR PROPER CITATION OF DIFFERENT TYPES OF SOURCES.

    **## WK2Instructions_MKTG201.docx**

    **Instructions**

    **Assignment Directions:**

    Objective: The goal of this assignment is to help you understand and apply the concept of market segmentation by analyzing the target market characteristics of a brand of your choice.

    When creating a target market profile, a common mistake is making it too broad—trying to include everyone instead of focusing on a specific group. Yes, big brands like Nike or Apple serve multiple audiences, but for this assignment, that’s not what we’re asking you to do. We want you to create one clear, highly detailed profile of a single target audience—just like a real marketer would when crafting a campaign. Think about who they are, what they care about, and why they buy. The more specific, the better. A well-defined target market doesn’t exclude anyone else from buying your product; it just sharpens the focus on who you’re trying to reach for specific campaigns. In reality, big companies have multiple target audience profiles, but for this assignment, we’re asking you to develop
    just one potential market segment. This is important because professional marketers need to identify advertising and promotional outlets that align with a specific target audience—and if the profile is too broad, that becomes nearly impossible.

    Use at least 2 market research resources to help you gather information and fill out the chart below.

    **Instructions:**

    1. Select a Brand: Choose a brand from one of the following categories:

    · Food brand
    **Cambell’s Soup**

    · Clothing company

    · Technology company

    · Automobile company

    · Airline company

    2. Describe the Brand: Write a 1–2 paragraph description of your chosen brand. Highlight its products or services, key history or milestones, and any unique qualities that make it stand out in the market.

    3. Complete the Chart: Create a chart in Word or Excel similar to the one below to identify and describe the market segmentation characteristics of the chosen brand. Fill in each section with relevant information based on your analysis of the brand’s target market. Use market research.

    | | |
    | — | — |
    | Segmentation Type | Enter Your Brand Name Here |
    | Demographics | |
    | Psychographics | |
    | Geographics | |
    | Behavioral Characteristics | |

    4. Conduct a Brief Analysis: Write a brief analysis explaining how the identified characteristics of the target market can influence the brand’s marketing strategy.

    **Submission Instructions:**

    · Please use: APA formatting using a cover page, 1-2 content page(s) and reference page. Word document. Include the above chart for your chosen brand in your paper.

    · Cover page

    · Content page

    · Content page

    · References

    **## Example_StudentPaperTemplateAPA7th.docx**

    | | |
    | — | — |
    | Running head: GUIDED IMAGERY AND PROGRESSIVE MUSCLE RELAXATION | 2 |

    1

    **Title of Paper in Bold Centered**

    Student Name

    American Public University

    COURSE####: Course Title

    Instructor Name

    Due Date

    **Repeat the Title – Level 1 Header**

    Hit the tab key one time to begin the main body of the paper. The paragraphs of the main document are indented. The computer will wrap your text for you based upon the margin settings established by this document template. It is not necessary for you to hit the Enter or return key at the end of a line of text. Only hit the enter key (one time) when you reach the end of a paragraph.

    Then hit the tab key to indent and then continue typing the paper. In APA any source that you use in your paper must have an in-text citation. In APA these citations include the author’s last name and the year of the publication in parentheses (Name, Year).

    **Level 2 Header use: Flush Left, Bold, Title Case Heading**

    Sub-section your essay using sub-headers in the same sequence you introduced your topic in your lead paragraph, your thesis.

    **_Level 3 Header use: Flush Left, Bold Italic, Title Case Heading_**

    The more lengthy or complex your essay, the potential for using additional Level Headers; notice the subtle difference. One tip for any submission, always double-check the font choice is consistent throughout the essay.

    **Conclusion – Level 1 Header**

    Begin to summarize the main points of your topic in three to five sentences. The conclusion of your paper should re-phrase the points of what your reader should be left remembering, nothing new, concise and to the point.

    **References – Level 1 Header**

    Lastname, C. (2008). Title of the source without caps except Proper Nouns or: First word after colon.
    _The Journal or Publication Italicized and Capped_, Vol#(Issue#), Page numbers.

    SEE APA GUIDELINES FOR PROPER CITATION OF DIFFERENT TYPES OF SOURCES.

    **## WK2Instructions_MKTG201.docx**

    **Instructions**

    **Assignment Directions:**

    Objective: The goal of this assignment is to help you understand and apply the concept of market segmentation by analyzing the target market characteristics of a brand of your choice.

    When creating a target market profile, a common mistake is making it too broad—trying to include everyone instead of focusing on a specific group. Yes, big brands like Nike or Apple serve multiple audiences, but for this assignment, that’s not what we’re asking you to do. We want you to create one clear, highly detailed profile of a single target audience—just like a real marketer would when crafting a campaign. Think about who they are, what they care about, and why they buy. The more specific, the better. A well-defined target market doesn’t exclude anyone else from buying your product; it just sharpens the focus on who you’re trying to reach for specific campaigns. In reality, big companies have multiple target audience profiles, but for this assignment, we’re asking you to develop
    just one potential market segment. This is important because professional marketers need to identify advertising and promotional outlets that align with a specific target audience—and if the profile is too broad, that becomes nearly impossible.

    Use at least 2 market research resources to help you gather information and fill out the chart below.

    **Instructions:**

    1. Select a Brand: Choose a brand from one of the following categories:

    · Food brand
    **Cambell’s Soup**

    · Clothing company

    · Technology company

    · Automobile company

    · Airline company

    2. Describe the Brand: Write a 1–2 paragraph description of your chosen brand. Highlight its products or services, key history or milestones, and any unique qualities that make it stand out in the market.

    3. Complete the Chart: Create a chart in Word or Excel similar to the one below to identify and describe the market segmentation characteristics of the chosen brand. Fill in each section with relevant information based on your analysis of the brand’s target market. Use market research.

    | | |
    | — | — |
    | Segmentation Type | Enter Your Brand Name Here |
    | Demographics | |
    | Psychographics | |
    | Geographics | |
    | Behavioral Characteristics | |

    4. Conduct a Brief Analysis: Write a brief analysis explaining how the identified characteristics of the target market can influence the brand’s marketing strategy.

    **Submission Instructions:**

    · Please use: APA formatting using a cover page, 1-2 content page(s) and reference page. Word document. Include the above chart for your chosen brand in your paper.

    · Cover page

    · Content page

    · Content page

    · References

    – 1
    – 2

  • [Solved] tutor

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering tutor.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] TUTOR

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering TUTOR.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] tutor

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering tutor.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] What is eco?

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    – ## Instructionsofproject.gdoc – IMG_1252.jpeg – IMG_1253.jpeg **## Instructionsofproject.gdoc** Using Spreadsheets to Gather and Formulate Macroeconomic Data (Submit assignment as a PDF) PDF available for printing There are three parts to this assignment (A, B & C). After each set of instruction…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    – ## Instructionsofproject.gdoc

    – IMG_1252.jpeg
    – IMG_1253.jpeg

    **## Instructionsofproject.gdoc**

    Using Spreadsheets to Gather and
    Formulate Macroeconomic Data (Submit
    assignment as a PDF)
    PDF available for printing

    There are three parts to this assignment (A, B & C). After each set of

    instructions, a video demonstration is provided.

    Getting Started:

    ● This assignment utilizes Google Drive and Google Spreadsheets. If you do not
    have Google Drive on your desktop, please follow the How to Download Google
    Drive instructions before continuing.

    ● If you use Excel regularly, you may convert the Google spreadsheet to an Excel
    spreadsheet.

    ● Please note that the directions refer to Google commands on a Chromebook or
    PC, which may differ from those in Excel or on a MacBook. Your use of either
    assumes that you understand and can use those functions in those formats.

    ● Once you are in this assignment, open the Macro Data Spreadsheet that has
    been shared with you.

    ● STOP AND MAKE A COPY of the Google Spreadsheet before changing or
    adding anything to the spreadsheet.

    ○ To make a copy, go to File>Make a Copy.
    ○ At the top of your new spreadsheet, below the title, add your name – "first name

    last name”.
    ● You can make changes to your spreadsheet by opening it in Google Drive.
    ● Once you have submitted the assignment, any changes you make will require you to

    resubmit it.

    A. Gathering Data, Step-by-Step Instructions:
    You will gather data for all columns on the spreadsheet in black font. You will formulate

    data for all columns in blue font. Instructions are clustered below by websites. The data

    links are embedded in the step-by-step instructions and listed below.

    [https://canvas.tccd.edu/courses/144870/files/24469893?wrap=1](https://canvas.tccd.edu/courses/144870/files/24469893?wrap=1)

    [https://support.google.com/a/users/answer/13022292?hl=en](https://support.google.com/a/users/answer/13022292?hl=en)

    [https://support.google.com/a/users/answer/13022292?hl=en](https://support.google.com/a/users/answer/13022292?hl=en)

    [https://docs.google.com/spreadsheets/d/1F9j7MqgLMwDjZmvjg5LcCmm72EgskXkTR3nMCCt1-Pc/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1F9j7MqgLMwDjZmvjg5LcCmm72EgskXkTR3nMCCt1-Pc/edit?usp=sharing)

    1.Nominal GDP/billion

    1. GDP Deflator Index

    2. Population/thousands

    3. Unemployment rate

    4. Consumer Price Index

    Nominal GDP and GDP Deflator

    ● Open the Nominal GDP link.

    ● When the web page opens, above the chart on the right-hand side, change the

    given dates to range from 1980-01-01 to 2024-01-01.

    ● Click Download in the upper right corner> Excel (data)

    ● When Excel opens, at the bottom of the sheet, click ANNUAL to see the data.

    Then click Enable Editing (at the top of the page), select all the data (not the

    titles) in both columns (dates and GDPA),and copy it.

    ● Open your Google Sheet template, select the first cell under YEAR, and paste

    the copied data. Use the Special Paste option>paste values only.

    ● Open the GDP Deflator link

    ● When the web page opens, above the chart on the right-hand side, change the

    date range to 1980-01-01 to 2024-01-01.

    ● Click on Edit Graph, then in Modify frequency > Annual and in Aggregation

    method > Average.

    ● Follow the remaining steps for NGDP above, except copy only the deflator

    data, not the years. Use the Special Paste option>paste values only

    Population

    ● Open the Population link.

    ● For Population, you will follow the instructions for Nominal GDP and GDP

    Deflator EXCEPT once you have downloaded the data to Excel (#1-3), BEFORE

    [https://fred.stlouisfed.org/series/GDPA](https://fred.stlouisfed.org/series/GDPA)

    [https://fred.stlouisfed.org/series/GDPDEF](https://fred.stlouisfed.org/series/GDPDEF)

    [https://fred.stlouisfed.org/series/B230RC0A052NBEA](https://fred.stlouisfed.org/series/B230RC0A052NBEA)

    [https://data.bls.gov/timeseries/LNS14000000](https://data.bls.gov/timeseries/LNS14000000)

    [https://data.bls.gov/timeseries/CUUR0000SA0](https://data.bls.gov/timeseries/CUUR0000SA0)

    [https://fred.stlouisfed.org/series/GDPA](https://fred.stlouisfed.org/series/GDPA)

    [https://fred.stlouisfed.org/series/GDPDEF](https://fred.stlouisfed.org/series/GDPDEF)

    [https://fred.stlouisfed.org/series/B230RC0A052NBEA](https://fred.stlouisfed.org/series/B230RC0A052NBEA)

    you copy and paste it on your sheet (#4), you must convert the data from millions

    to billions. (We are doing this now to make calculating Real GDP per capita

    easier)

    ○ If using a Chromebook, go to File>Save as a Google Sheet before

    continuing.

    ○ BEFORE transferring this data to your Google sheet, in the column next to

    the data on the first row of the data, type in = (this tells Google Sheets

    that you are inserting a formula), then type the following formula as-is:

    b12/1000000 (6 zeroes). Please note that"b12" identifies the first cell in

    your Nominal GDP column.

    ○ Hit Enter. The converted population number will appear.

    ○ Hover the mouse over that cell to find the black+ symbol in the bottom

    right corner of that cell and drag to the bottom of the column to copy the

    formula and populate data in all the cells.

    ● Highlight and copy the last column (the one you just formulated).

    ● Go to your Google Sheet and paste it in the Population column. Use the Special

    Paste option>paste values only.

    Unemployment

    ● Open the Unemployment link.

    ● At the top of the page, change the dates to 1980 to 2024, uncheck “Include

    Graphs,” and check “Include Annual Averages.” Click GO.

    ● Scroll down to data and above the schedule, click "Download.xslx".

    ● When the spreadsheet opens, click on Enable editing.

    ● You will not copy all of this into your spreadsheet. You only need the annual

    average. Since those did not self-populate, you will have Excel calculate those

    for you.

    [https://data.bls.gov/timeseries/LNS14000000](https://data.bls.gov/timeseries/LNS14000000)

    ○ If using a Chromebook, go to File>Save as a Google Sheet before

    continuing.

    ● In the first cell (1980 data) of the last column under Annual, type in the following

    formula as-is: =Average(b13:m13). Hit Enter, and the yearly average of the

    monthly unemployment rates will be entered into the cell. (Note: Instead of typing

    in the letter and number of the cell, you can click on the cell that will be used for

    the calculation.)

    ● In the bottom right corner of the cell with the new data, hover over it until you find

    the black + symbol, then drag the black + symbol to the bottom of the column

    to copy the formula and populate the data.

    ● BEFORE transferring this data to your Google sheet, in the cell to the left of the

    first row of the Annual column, type in the following formula:=n13/100. This

    converts a percentage to a decimal (to standardize how the data is formatted).

    ● In the bottom right corner of the cell, find the black + symbol, then drag it to the

    bottom of the column to copy the formula and populate the data.

    ● Highlight and copy only the data you just created.

    ● Go to your Google Sheet, and paste in the first cell in the Unemployment Annual

    Average Rate column. Use the Special Paste option>paste values only.

    Consumer Price Index

    ● Open the Consumer Price Index link,

    ● Click on "More Formatting Options".

    ● Leave everything in the "Select view of the data" box the same.

    ● In the "Select the time frame for your data" box, set the years to 1980-2024.

    ● Click on "Select one time period" and choose Annual Data.

    ● Uncheck "Include graphs".

    ● Leave everything else the same and click on "Retrieve Data".

    ● Highlight and copy the Annual column, then paste it into the Consumer Price

    Index column. Use the Special Paste option>paste values only.

    [https://data.bls.gov/timeseries/CUUR0000SA0](https://data.bls.gov/timeseries/CUUR0000SA0)

    . Using Formulas to Create New Data, Step-by-Step Instructions:

    ● You are now ready to use the data to formulate data for your blue columns. You

    will use the formula feature of your Google Sheet to do the calculations for you.

    However, you must tell it what to calculate by inserting a correct formula.

    ○ You will use your “Macroeconomic Formulas” handout for the basic

    formulas.

    Follow these directions to calculate the NGDP growth rate and use this example for the

    formula function for your other calculations that ask for a % change.

    ● Starting in the NGDP growth rate column, in the second row (1981), below the

    title type =(this tells Google Sheets that you are inserting a formula). Then tell

    Google Sheets the formula to use, replacing values with cell letters and numbers

    (see example below). Hit Enter to populate the cell.

    ○ On your Macroeconomic Formula sheet, you have formulas for Economic

    Growth Rate and Percent Change. These are the same formulas. You will

    use these steps for any data set that is a " % change".

    ● To calculate the NGDP Growth Rate for 1981, use the formula: (Current year

    GDP – Previous year GDP) / Previous year GDP. Do NOT multiply by 100.

    Instead of converting the decimal values to percentages, we will have the

    spreadsheet perform the conversion during Cleanup.

    ● Start on the row for 1981 in the NGDP Growth Rate column. (Note: We cannot

    calculate the growth rate for 1980 because we do not have data for 1979.)

    ● Using the data cells on your sheet, type in =(b6-b5)/b5. These letters and

    numbers reflect the second & first cells in your Nominal GDP column. (Note:

    Instead of typing in the letter and number of the cell, you can click on the cell that

    will be used for the calculation.)

    [https://canvas.tccd.edu/courses/144870/files/26451416?wrap=1](https://canvas.tccd.edu/courses/144870/files/26451416?wrap=1)

    [https://canvas.tccd.edu/courses/144870/files/24469895/download](https://canvas.tccd.edu/courses/144870/files/24469895/download)

    ● Populate the entire column by finding the black + symbol in the bottom right

    corner of the cell you formulated and dragging it down to the bottom of the

    column. This will copy the formula.

    ● At this point, you have used the formula feature for several calculations. Repeat

    those steps for all required calculations using the appropriate formulas from your

    formula sheet with the appropriate data on your sheet.

    ● The first row of any rate-of-change/growth-rate column will NOT be calculated,

    as there is no previous data to calculate it. You will start with the 2nd row on all

    of these.

    ● To calculate Real GDP, use the formula from your formula sheet that employs the

    GDP Deflator.

    ● If you are still unsure about doing this, watch the video demonstration.

    ● All columns, including the titles, should be formatted from the right margin.

    ● Adjust the cell size so the column titles are legible.

    ● The font type and size should be the same throughout.

    ○ Highlight all your data. Choose a font size and type.

    ● Check that you have data for every year listed except the "% Change" columns

    for 1980.

    ● Check that you do not have a value of 100 at the bottom of any of your growth

    rate or rate of change columns. If you do, it is because you did not skip the first

    row of those columns. To correct, cut and paste everything in that column, one

    row down.

    ●

    – Using Spreadsheets to Gather and Formulate Macroeconomic Data (Submit assignment as a PDF)
    – Getting Started:
    – A. Gathering Data, Step-by-Step Instructions:
    – . Using Formulas to Create New Data, Step-by-Step Instructions:

    **IMG_1252.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-1252-jpeg-10468397)

    **IMG_1253.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-1253-jpeg-10468399)

    **IMG_1253.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-1253-jpeg-10468399)

    **## Instructionsofproject.gdoc**

    Using Spreadsheets to Gather and
    Formulate Macroeconomic Data (Submit
    assignment as a PDF)
    PDF available for printing

    There are three parts to this assignment (A, B & C). After each set of

    instructions, a video demonstration is provided.

    Getting Started:

    ● This assignment utilizes Google Drive and Google Spreadsheets. If you do not
    have Google Drive on your desktop, please follow the How to Download Google
    Drive instructions before continuing.

    ● If you use Excel regularly, you may convert the Google spreadsheet to an Excel
    spreadsheet.

    ● Please note that the directions refer to Google commands on a Chromebook or
    PC, which may differ from those in Excel or on a MacBook. Your use of either
    assumes that you understand and can use those functions in those formats.

    ● Once you are in this assignment, open the Macro Data Spreadsheet that has
    been shared with you.

    ● STOP AND MAKE A COPY of the Google Spreadsheet before changing or
    adding anything to the spreadsheet.

    ○ To make a copy, go to File>Make a Copy.
    ○ At the top of your new spreadsheet, below the title, add your name – "first name

    last name”.
    ● You can make changes to your spreadsheet by opening it in Google Drive.
    ● Once you have submitted the assignment, any changes you make will require you to

    resubmit it.

    A. Gathering Data, Step-by-Step Instructions:
    You will gather data for all columns on the spreadsheet in black font. You will formulate

    data for all columns in blue font. Instructions are clustered below by websites. The data

    links are embedded in the step-by-step instructions and listed below.

    [https://canvas.tccd.edu/courses/144870/files/24469893?wrap=1](https://canvas.tccd.edu/courses/144870/files/24469893?wrap=1)

    [https://support.google.com/a/users/answer/13022292?hl=en](https://support.google.com/a/users/answer/13022292?hl=en)

    [https://support.google.com/a/users/answer/13022292?hl=en](https://support.google.com/a/users/answer/13022292?hl=en)

    [https://docs.google.com/spreadsheets/d/1F9j7MqgLMwDjZmvjg5LcCmm72EgskXkTR3nMCCt1-Pc/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1F9j7MqgLMwDjZmvjg5LcCmm72EgskXkTR3nMCCt1-Pc/edit?usp=sharing)

    1.Nominal GDP/billion

    1. GDP Deflator Index

    2. Population/thousands

    3. Unemployment rate

    4. Consumer Price Index

    Nominal GDP and GDP Deflator

    ● Open the Nominal GDP link.

    ● When the web page opens, above the chart on the right-hand side, change the

    given dates to range from 1980-01-01 to 2024-01-01.

    ● Click Download in the upper right corner> Excel (data)

    ● When Excel opens, at the bottom of the sheet, click ANNUAL to see the data.

    Then click Enable Editing (at the top of the page), select all the data (not the

    titles) in both columns (dates and GDPA),and copy it.

    ● Open your Google Sheet template, select the first cell under YEAR, and paste

    the copied data. Use the Special Paste option>paste values only.

    ● Open the GDP Deflator link

    ● When the web page opens, above the chart on the right-hand side, change the

    date range to 1980-01-01 to 2024-01-01.

    ● Click on Edit Graph, then in Modify frequency > Annual and in Aggregation

    method > Average.

    ● Follow the remaining steps for NGDP above, except copy only the deflator

    data, not the years. Use the Special Paste option>paste values only

    Population

    ● Open the Population link.

    ● For Population, you will follow the instructions for Nominal GDP and GDP

    Deflator EXCEPT once you have downloaded the data to Excel (#1-3), BEFORE

    [https://fred.stlouisfed.org/series/GDPA](https://fred.stlouisfed.org/series/GDPA)

    [https://fred.stlouisfed.org/series/GDPDEF](https://fred.stlouisfed.org/series/GDPDEF)

    [https://fred.stlouisfed.org/series/B230RC0A052NBEA](https://fred.stlouisfed.org/series/B230RC0A052NBEA)

    [https://data.bls.gov/timeseries/LNS14000000](https://data.bls.gov/timeseries/LNS14000000)

    [https://data.bls.gov/timeseries/CUUR0000SA0](https://data.bls.gov/timeseries/CUUR0000SA0)

    [https://fred.stlouisfed.org/series/GDPA](https://fred.stlouisfed.org/series/GDPA)

    [https://fred.stlouisfed.org/series/GDPDEF](https://fred.stlouisfed.org/series/GDPDEF)

    [https://fred.stlouisfed.org/series/B230RC0A052NBEA](https://fred.stlouisfed.org/series/B230RC0A052NBEA)

    you copy and paste it on your sheet (#4), you must convert the data from millions

    to billions. (We are doing this now to make calculating Real GDP per capita

    easier)

    ○ If using a Chromebook, go to File>Save as a Google Sheet before

    continuing.

    ○ BEFORE transferring this data to your Google sheet, in the column next to

    the data on the first row of the data, type in = (this tells Google Sheets

    that you are inserting a formula), then type the following formula as-is:

    b12/1000000 (6 zeroes). Please note that"b12" identifies the first cell in

    your Nominal GDP column.

    ○ Hit Enter. The converted population number will appear.

    ○ Hover the mouse over that cell to find the black+ symbol in the bottom

    right corner of that cell and drag to the bottom of the column to copy the

    formula and populate data in all the cells.

    ● Highlight and copy the last column (the one you just formulated).

    ● Go to your Google Sheet and paste it in the Population column. Use the Special

    Paste option>paste values only.

    Unemployment

    ● Open the Unemployment link.

    ● At the top of the page, change the dates to 1980 to 2024, uncheck “Include

    Graphs,” and check “Include Annual Averages.” Click GO.

    ● Scroll down to data and above the schedule, click "Download.xslx".

    ● When the spreadsheet opens, click on Enable editing.

    ● You will not copy all of this into your spreadsheet. You only need the annual

    average. Since those did not self-populate, you will have Excel calculate those

    for you.

    [https://data.bls.gov/timeseries/LNS14000000](https://data.bls.gov/timeseries/LNS14000000)

    ○ If using a Chromebook, go to File>Save as a Google Sheet before

    continuing.

    ● In the first cell (1980 data) of the last column under Annual, type in the following

    formula as-is: =Average(b13:m13). Hit Enter, and the yearly average of the

    monthly unemployment rates will be entered into the cell. (Note: Instead of typing

    in the letter and number of the cell, you can click on the cell that will be used for

    the calculation.)

    ● In the bottom right corner of the cell with the new data, hover over it until you find

    the black + symbol, then drag the black + symbol to the bottom of the column

    to copy the formula and populate the data.

    ● BEFORE transferring this data to your Google sheet, in the cell to the left of the

    first row of the Annual column, type in the following formula:=n13/100. This

    converts a percentage to a decimal (to standardize how the data is formatted).

    ● In the bottom right corner of the cell, find the black + symbol, then drag it to the

    bottom of the column to copy the formula and populate the data.

    ● Highlight and copy only the data you just created.

    ● Go to your Google Sheet, and paste in the first cell in the Unemployment Annual

    Average Rate column. Use the Special Paste option>paste values only.

    Consumer Price Index

    ● Open the Consumer Price Index link,

    ● Click on "More Formatting Options".

    ● Leave everything in the "Select view of the data" box the same.

    ● In the "Select the time frame for your data" box, set the years to 1980-2024.

    ● Click on "Select one time period" and choose Annual Data.

    ● Uncheck "Include graphs".

    ● Leave everything else the same and click on "Retrieve Data".

    ● Highlight and copy the Annual column, then paste it into the Consumer Price

    Index column. Use the Special Paste option>paste values only.

    [https://data.bls.gov/timeseries/CUUR0000SA0](https://data.bls.gov/timeseries/CUUR0000SA0)

    . Using Formulas to Create New Data, Step-by-Step Instructions:

    ● You are now ready to use the data to formulate data for your blue columns. You

    will use the formula feature of your Google Sheet to do the calculations for you.

    However, you must tell it what to calculate by inserting a correct formula.

    ○ You will use your “Macroeconomic Formulas” handout for the basic

    formulas.

    Follow these directions to calculate the NGDP growth rate and use this example for the

    formula function for your other calculations that ask for a % change.

    ● Starting in the NGDP growth rate column, in the second row (1981), below the

    title type =(this tells Google Sheets that you are inserting a formula). Then tell

    Google Sheets the formula to use, replacing values with cell letters and numbers

    (see example below). Hit Enter to populate the cell.

    ○ On your Macroeconomic Formula sheet, you have formulas for Economic

    Growth Rate and Percent Change. These are the same formulas. You will

    use these steps for any data set that is a " % change".

    ● To calculate the NGDP Growth Rate for 1981, use the formula: (Current year

    GDP – Previous year GDP) / Previous year GDP. Do NOT multiply by 100.

    Instead of converting the decimal values to percentages, we will have the

    spreadsheet perform the conversion during Cleanup.

    ● Start on the row for 1981 in the NGDP Growth Rate column. (Note: We cannot

    calculate the growth rate for 1980 because we do not have data for 1979.)

    ● Using the data cells on your sheet, type in =(b6-b5)/b5. These letters and

    numbers reflect the second & first cells in your Nominal GDP column. (Note:

    Instead of typing in the letter and number of the cell, you can click on the cell that

    will be used for the calculation.)

    [https://canvas.tccd.edu/courses/144870/files/26451416?wrap=1](https://canvas.tccd.edu/courses/144870/files/26451416?wrap=1)

    [https://canvas.tccd.edu/courses/144870/files/24469895/download](https://canvas.tccd.edu/courses/144870/files/24469895/download)

    ● Populate the entire column by finding the black + symbol in the bottom right

    corner of the cell you formulated and dragging it down to the bottom of the

    column. This will copy the formula.

    ● At this point, you have used the formula feature for several calculations. Repeat

    those steps for all required calculations using the appropriate formulas from your

    formula sheet with the appropriate data on your sheet.

    ● The first row of any rate-of-change/growth-rate column will NOT be calculated,

    as there is no previous data to calculate it. You will start with the 2nd row on all

    of these.

    ● To calculate Real GDP, use the formula from your formula sheet that employs the

    GDP Deflator.

    ● If you are still unsure about doing this, watch the video demonstration.

    ● All columns, including the titles, should be formatted from the right margin.

    ● Adjust the cell size so the column titles are legible.

    ● The font type and size should be the same throughout.

    ○ Highlight all your data. Choose a font size and type.

    ● Check that you have data for every year listed except the "% Change" columns

    for 1980.

    ● Check that you do not have a value of 100 at the bottom of any of your growth

    rate or rate of change columns. If you do, it is because you did not skip the first

    row of those columns. To correct, cut and paste everything in that column, one

    row down.

    ●

    – Using Spreadsheets to Gather and Formulate Macroeconomic Data (Submit assignment as a PDF)
    – Getting Started:
    – A. Gathering Data, Step-by-Step Instructions:
    – . Using Formulas to Create New Data, Step-by-Step Instructions:

    **IMG_1252.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-1252-jpeg-10468397)

    **IMG_1253.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-1253-jpeg-10468399)

    **## Instructionsofproject.gdoc**

    Using Spreadsheets to Gather and
    Formulate Macroeconomic Data (Submit
    assignment as a PDF)
    PDF available for printing

    There are three parts to this assignment (A, B & C). After each set of

    instructions, a video demonstration is provided.

    Getting Started:

    ● This assignment utilizes Google Drive and Google Spreadsheets. If you do not
    have Google Drive on your desktop, please follow the How to Download Google
    Drive instructions before continuing.

    ● If you use Excel regularly, you may convert the Google spreadsheet to an Excel
    spreadsheet.

    ● Please note that the directions refer to Google commands on a Chromebook or
    PC, which may differ from those in Excel or on a MacBook. Your use of either
    assumes that you understand and can use those functions in those formats.

    ● Once you are in this assignment, open the Macro Data Spreadsheet that has
    been shared with you.

    ● STOP AND MAKE A COPY of the Google Spreadsheet before changing or
    adding anything to the spreadsheet.

    ○ To make a copy, go to File>Make a Copy.
    ○ At the top of your new spreadsheet, below the title, add your name – "first name

    last name”.
    ● You can make changes to your spreadsheet by opening it in Google Drive.
    ● Once you have submitted the assignment, any changes you make will require you to

    resubmit it.

    A. Gathering Data, Step-by-Step Instructions:
    You will gather data for all columns on the spreadsheet in black font. You will formulate

    data for all columns in blue font. Instructions are clustered below by websites. The data

    links are embedded in the step-by-step instructions and listed below.

    [https://canvas.tccd.edu/courses/144870/files/24469893?wrap=1](https://canvas.tccd.edu/courses/144870/files/24469893?wrap=1)

    [https://support.google.com/a/users/answer/13022292?hl=en](https://support.google.com/a/users/answer/13022292?hl=en)

    [https://support.google.com/a/users/answer/13022292?hl=en](https://support.google.com/a/users/answer/13022292?hl=en)

    [https://docs.google.com/spreadsheets/d/1F9j7MqgLMwDjZmvjg5LcCmm72EgskXkTR3nMCCt1-Pc/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1F9j7MqgLMwDjZmvjg5LcCmm72EgskXkTR3nMCCt1-Pc/edit?usp=sharing)

    1.Nominal GDP/billion

    1. GDP Deflator Index

    2. Population/thousands

    3. Unemployment rate

    4. Consumer Price Index

    Nominal GDP and GDP Deflator

    ● Open the Nominal GDP link.

    ● When the web page opens, above the chart on the right-hand side, change the

    given dates to range from 1980-01-01 to 2024-01-01.

    ● Click Download in the upper right corner> Excel (data)

    ● When Excel opens, at the bottom of the sheet, click ANNUAL to see the data.

    Then click Enable Editing (at the top of the page), select all the data (not the

    titles) in both columns (dates and GDPA),and copy it.

    ● Open your Google Sheet template, select the first cell under YEAR, and paste

    the copied data. Use the Special Paste option>paste values only.

    ● Open the GDP Deflator link

    ● When the web page opens, above the chart on the right-hand side, change the

    date range to 1980-01-01 to 2024-01-01.

    ● Click on Edit Graph, then in Modify frequency > Annual and in Aggregation

    method > Average.

    ● Follow the remaining steps for NGDP above, except copy only the deflator

    data, not the years. Use the Special Paste option>paste values only

    Population

    ● Open the Population link.

    ● For Population, you will follow the instructions for Nominal GDP and GDP

    Deflator EXCEPT once you have downloaded the data to Excel (#1-3), BEFORE

    [https://fred.stlouisfed.org/series/GDPA](https://fred.stlouisfed.org/series/GDPA)

    [https://fred.stlouisfed.org/series/GDPDEF](https://fred.stlouisfed.org/series/GDPDEF)

    [https://fred.stlouisfed.org/series/B230RC0A052NBEA](https://fred.stlouisfed.org/series/B230RC0A052NBEA)

    [https://data.bls.gov/timeseries/LNS14000000](https://data.bls.gov/timeseries/LNS14000000)

    [https://data.bls.gov/timeseries/CUUR0000SA0](https://data.bls.gov/timeseries/CUUR0000SA0)

    [https://fred.stlouisfed.org/series/GDPA](https://fred.stlouisfed.org/series/GDPA)

    [https://fred.stlouisfed.org/series/GDPDEF](https://fred.stlouisfed.org/series/GDPDEF)

    [https://fred.stlouisfed.org/series/B230RC0A052NBEA](https://fred.stlouisfed.org/series/B230RC0A052NBEA)

    you copy and paste it on your sheet (#4), you must convert the data from millions

    to billions. (We are doing this now to make calculating Real GDP per capita

    easier)

    ○ If using a Chromebook, go to File>Save as a Google Sheet before

    continuing.

    ○ BEFORE transferring this data to your Google sheet, in the column next to

    the data on the first row of the data, type in = (this tells Google Sheets

    that you are inserting a formula), then type the following formula as-is:

    b12/1000000 (6 zeroes). Please note that"b12" identifies the first cell in

    your Nominal GDP column.

    ○ Hit Enter. The converted population number will appear.

    ○ Hover the mouse over that cell to find the black+ symbol in the bottom

    right corner of that cell and drag to the bottom of the column to copy the

    formula and populate data in all the cells.

    ● Highlight and copy the last column (the one you just formulated).

    ● Go to your Google Sheet and paste it in the Population column. Use the Special

    Paste option>paste values only.

    Unemployment

    ● Open the Unemployment link.

    ● At the top of the page, change the dates to 1980 to 2024, uncheck “Include

    Graphs,” and check “Include Annual Averages.” Click GO.

    ● Scroll down to data and above the schedule, click "Download.xslx".

    ● When the spreadsheet opens, click on Enable editing.

    ● You will not copy all of this into your spreadsheet. You only need the annual

    average. Since those did not self-populate, you will have Excel calculate those

    for you.

    [https://data.bls.gov/timeseries/LNS14000000](https://data.bls.gov/timeseries/LNS14000000)

    ○ If using a Chromebook, go to File>Save as a Google Sheet before

    continuing.

    ● In the first cell (1980 data) of the last column under Annual, type in the following

    formula as-is: =Average(b13:m13). Hit Enter, and the yearly average of the

    monthly unemployment rates will be entered into the cell. (Note: Instead of typing

    in the letter and number of the cell, you can click on the cell that will be used for

    the calculation.)

    ● In the bottom right corner of the cell with the new data, hover over it until you find

    the black + symbol, then drag the black + symbol to the bottom of the column

    to copy the formula and populate the data.

    ● BEFORE transferring this data to your Google sheet, in the cell to the left of the

    first row of the Annual column, type in the following formula:=n13/100. This

    converts a percentage to a decimal (to standardize how the data is formatted).

    ● In the bottom right corner of the cell, find the black + symbol, then drag it to the

    bottom of the column to copy the formula and populate the data.

    ● Highlight and copy only the data you just created.

    ● Go to your Google Sheet, and paste in the first cell in the Unemployment Annual

    Average Rate column. Use the Special Paste option>paste values only.

    Consumer Price Index

    ● Open the Consumer Price Index link,

    ● Click on "More Formatting Options".

    ● Leave everything in the "Select view of the data" box the same.

    ● In the "Select the time frame for your data" box, set the years to 1980-2024.

    ● Click on "Select one time period" and choose Annual Data.

    ● Uncheck "Include graphs".

    ● Leave everything else the same and click on "Retrieve Data".

    ● Highlight and copy the Annual column, then paste it into the Consumer Price

    Index column. Use the Special Paste option>paste values only.

    [https://data.bls.gov/timeseries/CUUR0000SA0](https://data.bls.gov/timeseries/CUUR0000SA0)

    . Using Formulas to Create New Data, Step-by-Step Instructions:

    ● You are now ready to use the data to formulate data for your blue columns. You

    will use the formula feature of your Google Sheet to do the calculations for you.

    However, you must tell it what to calculate by inserting a correct formula.

    ○ You will use your “Macroeconomic Formulas” handout for the basic

    formulas.

    Follow these directions to calculate the NGDP growth rate and use this example for the

    formula function for your other calculations that ask for a % change.

    ● Starting in the NGDP growth rate column, in the second row (1981), below the

    title type =(this tells Google Sheets that you are inserting a formula). Then tell

    Google Sheets the formula to use, replacing values with cell letters and numbers

    (see example below). Hit Enter to populate the cell.

    ○ On your Macroeconomic Formula sheet, you have formulas for Economic

    Growth Rate and Percent Change. These are the same formulas. You will

    use these steps for any data set that is a " % change".

    ● To calculate the NGDP Growth Rate for 1981, use the formula: (Current year

    GDP – Previous year GDP) / Previous year GDP. Do NOT multiply by 100.

    Instead of converting the decimal values to percentages, we will have the

    spreadsheet perform the conversion during Cleanup.

    ● Start on the row for 1981 in the NGDP Growth Rate column. (Note: We cannot

    calculate the growth rate for 1980 because we do not have data for 1979.)

    ● Using the data cells on your sheet, type in =(b6-b5)/b5. These letters and

    numbers reflect the second & first cells in your Nominal GDP column. (Note:

    Instead of typing in the letter and number of the cell, you can click on the cell that

    will be used for the calculation.)

    [https://canvas.tccd.edu/courses/144870/files/26451416?wrap=1](https://canvas.tccd.edu/courses/144870/files/26451416?wrap=1)

    [https://canvas.tccd.edu/courses/144870/files/24469895/download](https://canvas.tccd.edu/courses/144870/files/24469895/download)

    ● Populate the entire column by finding the black + symbol in the bottom right

    corner of the cell you formulated and dragging it down to the bottom of the

    column. This will copy the formula.

    ● At this point, you have used the formula feature for several calculations. Repeat

    those steps for all required calculations using the appropriate formulas from your

    formula sheet with the appropriate data on your sheet.

    ● The first row of any rate-of-change/growth-rate column will NOT be calculated,

    as there is no previous data to calculate it. You will start with the 2nd row on all

    of these.

    ● To calculate Real GDP, use the formula from your formula sheet that employs the

    GDP Deflator.

    ● If you are still unsure about doing this, watch the video demonstration.

    ● All columns, including the titles, should be formatted from the right margin.

    ● Adjust the cell size so the column titles are legible.

    ● The font type and size should be the same throughout.

    ○ Highlight all your data. Choose a font size and type.

    ● Check that you have data for every year listed except the "% Change" columns

    for 1980.

    ● Check that you do not have a value of 100 at the bottom of any of your growth

    rate or rate of change columns. If you do, it is because you did not skip the first

    row of those columns. To correct, cut and paste everything in that column, one

    row down.

    ●

    – Using Spreadsheets to Gather and Formulate Macroeconomic Data (Submit assignment as a PDF)
    – Getting Started:
    – A. Gathering Data, Step-by-Step Instructions:
    – . Using Formulas to Create New Data, Step-by-Step Instructions:

    **IMG_1252.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-1252-jpeg-10468397)

    **IMG_1253.jpeg**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/img-1253-jpeg-10468399)

    – 1
    – 2
    – 3

  • [Solved] tutor

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering tutor.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.