Scribd Logo
Upload

Welcome to Scribd!

  • 108 views

    STA641 Assignment 1 Solution Spring 2021

    Uploaded by

    Muhammad Zeeshan
    This document contains quarterly revenue data for Amazon from 1996 and 2017. It shows there was a significant increase in revenue amounts over the 21 year period. The median revenue between the middle observations (quarters) of 1996 is $17,861.2, while the average (mean) total revenue for 2017 was $222,235.2 million. The total revenue for 2017 was over $177 billion. Comparing the mean and median between 1996 and 2017 shows how the distribution of the revenue data changed dramatically as Amazon grew substantially over the two decades.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    STA641 Assignment 1 Solution Spring 2021

    Uploaded by

    Muhammad Zeeshan
    108 views5 pages
    This document contains quarterly revenue data for Amazon from 1996 and 2017. It shows there was a significant increase in revenue amounts over the 21 year period. The median revenue between the middle observations (quarters) of 1996 is $17,861.2, while the average (mean) total revenue for 2017 was $222,235.2 million. The total revenue for 2017 was over $177 billion. Comparing the mean and median between 1996 and 2017 shows how the distribution of the revenue data changed dramatically as Amazon grew substantially over the two decades.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains quarterly revenue data for Amazon from 1996 and 2017. It shows there was a significant increase in revenue amounts over the 21 year period. The median revenue between the middle observations (quarters) of 1996 is $17,861.2, while the average (mean) total revenue for 2017 was $222,235.2 million. The total revenue for 2017 was over $177 billion. Comparing the mean and median between 1996 and 2017 shows how the distribution of the revenue data changed dramatically as Amazon grew substantially over the two decades.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    108 views5 pages

    STA641 Assignment 1 Solution Spring 2021

    Uploaded by

    Muhammad Zeeshan
    This document contains quarterly revenue data for Amazon from 1996 and 2017. It shows there was a significant increase in revenue amounts over the 21 year period. The median revenue between the middle observations (quarters) of 1996 is $17,861.2, while the average (mean) total revenue for 2017 was $222,235.2 million. The total revenue for 2017 was over $177 billion. Comparing the mean and median between 1996 and 2017 shows how the distribution of the revenue data changed dramatically as Amazon grew substantially over the two decades.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    Revenue

    Year Observation Date (Millions)


    1 3/28/1996 0.9
    2 6/28/1996 2.2
    1996
    3 9/28/1996 4.2
    4 12/28/1996 8.4
    5 3/28/2017 35714
    6 6/28/2017 37955
    2017
    7 9/28/2017 43744
    8 12/28/2017 60453
    Count 8

    Average Between Middle Observations (4 & 5) 17861.2

    Median 17861.2

    Mean 22235.2125

    Total Revenue of Year 2017 177866


    Spring 2021_STA641_Assignment 1

    Here is the Amazon's quarterly revenue from their first year - 1996 - and a more recent year - 2017.
    Let's compare the mean and the median revenue between the two quarters to see how the data is
    distributed. The median is more robust to outliers, unlike the mean. So if your dataset has a lot of
    outliers, the mean will be pulled in the direction of the outliers.

    Recall that for an odd number of observations, a median is the middle value in the data. With an even
    number of observations, the median is the mean of the two middle values. To manually calculate a
    median, the data needs to be sorted (unlike if you are using the MEDIAN() function). This data is
    naturally ascending, so no sorting is necessary.

    Now you are required to do this on "Assignment 1 Data" sheet


    ·        In cell G1, count the number of observation of in range D2:D9
    ·        In cell G3, calculate the average for the middle observations, D5 and D6.
    ·        Now use direct function to find median in G5 passing in all revenue amounts, D2:D9.
    ·        In cell G7, calculate the mean of D2:D9.
    ·        In cell G9, calculate the total revenue of Year 2017

    After solving it, Save it and then submit/upload to VULMS Assignment page.
    Also fill this Answer form: https://forms.gle/AKygQUwicSM7jgq1A
    Some Key Points About Assignment 1

    1. Download Your First Assignment from VULMS > STA641 > Assignment

    2. The Assignment File is in MS Excel. Open the file in MS Excel.

    3. There are three sheets with the name “Assignment 1 Data” and “How to solve” and "Key Points"

    4. The question statement, Instruction and What is required by you is mentioned in “How to solve”. Read it carefu

    5. After understanding the question, Go to the sheet with the name “Assignment 1 Data” and apply the appropria

    6. After completing, save this file in your system.

    7. Now go to the Assignment page of your VULMS and SUBMIT / UPLOAD this assignment. 

    8. Now, one more thing needs to be one. Open this google form and answer the questions from the Assignment 1

    9. This form will be accessible/open only using your VU Email account. Make sure you are using VU Gmail login.

    10. Fill the form and submit it. https://forms.gle/LQrxx4Nse6AQiuvF9

    At the end, make sure:


    You have uploaded/submitted your assignment in VULMS
    You have filled the answer sheet which is available in this google form. 
    le/LQrxx4Nse6AQiuvF9

    You might also like