Scribd Logo
Upload

Welcome to Scribd!

  • 325 views

    Assignment Number 1

    Uploaded by

    Muhammad Muzammil
    This document contains instructions for Assignment 1 which is to be completed manually in Microsoft Excel and submitted by July 17th, 2019. It consists of 4 questions. Question 1 involves analyzing frequency distributions and creating a bar chart to identify the most and second most frequently visited websites from sample data. Question 2 involves creating various frequency and cumulative frequency distributions and a histogram to analyze how much time CEOs spend in meetings. Question 3 involves calculating measures of central tendency, variability, percentiles and creating a box plot from sample data. Question 4 involves creating a scatter plot and computing and interpreting the covariance and correlation coefficient from bivariate sample data.

    Copyright:

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

    Assignment Number 1

    Uploaded by

    Muhammad Muzammil
    325 views2 pages
    This document contains instructions for Assignment 1 which is to be completed manually in Microsoft Excel and submitted by July 17th, 2019. It consists of 4 questions. Question 1 involves analyzing frequency distributions and creating a bar chart to identify the most and second most frequently visited websites from sample data. Question 2 involves creating various frequency and cumulative frequency distributions and a histogram to analyze how much time CEOs spend in meetings. Question 3 involves calculating measures of central tendency, variability, percentiles and creating a box plot from sample data. Question 4 involves creating a scatter plot and computing and interpreting the covariance and correlation coefficient from bivariate sample data.

    Original Description:

    It is the assignment.. Kindly solve it

    Original Title

    Assignment Number 1 (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains instructions for Assignment 1 which is to be completed manually in Microsoft Excel and submitted by July 17th, 2019. It consists of 4 questions. Question 1 involves analyzing frequency distributions and creating a bar chart to identify the most and second most frequently visited websites from sample data. Question 2 involves creating various frequency and cumulative frequency distributions and a histogram to analyze how much time CEOs spend in meetings. Question 3 involves calculating measures of central tendency, variability, percentiles and creating a box plot from sample data. Question 4 involves creating a scatter plot and computing and interpreting the covariance and correlation coefficient from bivariate sample data.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    325 views2 pages

    Assignment Number 1

    Uploaded by

    Muhammad Muzammil
    This document contains instructions for Assignment 1 which is to be completed manually in Microsoft Excel and submitted by July 17th, 2019. It consists of 4 questions. Question 1 involves analyzing frequency distributions and creating a bar chart to identify the most and second most frequently visited websites from sample data. Question 2 involves creating various frequency and cumulative frequency distributions and a histogram to analyze how much time CEOs spend in meetings. Question 3 involves calculating measures of central tendency, variability, percentiles and creating a box plot from sample data. Question 4 involves creating a scatter plot and computing and interpreting the covariance and correlation coefficient from bivariate sample data.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    Assignment Number 1

    This assignment is to be done manually. For practice/assistance use Microsoft Excel. The
    assignment is of 10 marks and is to be submitted by July of 17th 2019. Please ensure that the
    assignment is in presentable form and has not been copied.

    Q1. In a recent report, the top five most-visited English-language web sites were google.com
    (GOOG), facebook.com (FB), youtube.com (YT), yahoo.com (YAH), and wikipedia.com (WIKI).
    The most-visited web sites for a sample of 50 Internet users are shown in the following table:

    YAH WIKI YT WIKI GOOG


    YT YAH GOOG GOOG GOOG
    WIKI GOOG YAH YAH YAH
    YAH YT GOOG YT YAH
    GOOG FB FB WIKI GOOG
    GOOG GOOG FB FB WIKI
    FB YAH YT YAH YAH
    YT GOOG YAH FB FB
    WIKI GOOG YAH WIKI WIKI
    YAH YT GOOG GOOG WIKI

    a. Provide frequency and percent frequency distributions.


    b. Make a bar chart.
    c. On the basis of the sample, which web site is most frequently the most-often-visited web
    site for Internet users? Which is second?

    Q2. In a study of how chief executive officers (CEOs) spend their days, it was found that CEOs
    spend an average of about 18 hours per week in meetings, not including conference calls, business
    meals, and public events. Shown here are the times spent per week in meetings (hours) for a sample
    of 25 CEOs:

    14 15 18 23 15
    19 20 13 15 23
    23 21 15 20 21
    16 15 18 18 19
    19 22 23 21 12

    a. Prepare a frequency distribution, relative frequency distribution and a percent frequency


    distribution for the data.
    b. Prepare cumulative frequency distribution, relative cumulative frequency distribution and
    percent cumulative frequency distribution for the data.
    c. Prepare a histogram and comment on the shape of the distribution.
    Q3. Consider the following data set:

    24 67 17 20 31 44 12 23 16 37

    a. Calculate mean, median and mode


    b. Calculate variance and standard deviation and coefficient of variation
    c. Calculate Z-scores.
    d. Find the 65th percentile of this data set.
    e. Draw a box plot for this data.

    Q4. Consider the following data set for variables x and y:

    x 4 6 11 3 16
    y 50 50 40 60 30

    a. Develop a scatter diagram


    b. What does the scatter diagram developed in part indicate about the relationship between
    the two variables?
    c. Compute and interpret the sample covariance.
    d. Compute and interpret the sample correlation coefficient.

    You might also like