Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    Week5 Histograms Spreadsheet

    Uploaded by

    Jatin Garg
    1. The document describes a frequency histogram of data values binned into ranges. It shows the bins, counts of data points in each bin, and calculates the total number of data points. 2. It then converts the frequency histogram to a probability histogram by dividing the counts in each bin by the total number of data points. This gives the probability of a value falling into each bin. 3. Some key metrics are calculated from the data inputs and probability histogram bins, including the mean, variance, and skewness of the original data and bin midpoints.

    Copyright:

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

    Week5 Histograms Spreadsheet

    Uploaded by

    Jatin Garg
    20 views12 pages
    1. The document describes a frequency histogram of data values binned into ranges. It shows the bins, counts of data points in each bin, and calculates the total number of data points. 2. It then converts the frequency histogram to a probability histogram by dividing the counts in each bin by the total number of data points. This gives the probability of a value falling into each bin. 3. Some key metrics are calculated from the data inputs and probability histogram bins, including the mean, variance, and skewness of the original data and bin midpoints.

    Original Description:

    histogram details

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. The document describes a frequency histogram of data values binned into ranges. It shows the bins, counts of data points in each bin, and calculates the total number of data points. 2. It then converts the frequency histogram to a probability histogram by dividing the counts in each bin by the total number of data points. This gives the probability of a value falling into each bin. 3. Some key metrics are calculated from the data inputs and probability histogram bins, including the mean, variance, and skewness of the original data and bin midpoints.

    Copyright:

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

    Week5 Histograms Spreadsheet

    Uploaded by

    Jatin Garg
    1. The document describes a frequency histogram of data values binned into ranges. It shows the bins, counts of data points in each bin, and calculates the total number of data points. 2. It then converts the frequency histogram to a probability histogram by dividing the counts in each bin by the total number of data points. This gives the probability of a value falling into each bin. 3. Some key metrics are calculated from the data inputs and probability histogram bins, including the mean, variance, and skewness of the original data and bin midpoints.

    Copyright:

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

    1.

    Frequency Histogram
    Bins are chosen to cover the range of values in the dat
    from >= to <
    Bin 1 -0.3 -0.2
    Bin 2 -0.2 -0.1
    Bin 3 -0.1 0
    Bin 4 0 0.1
    Bin 5 0.1 0.2

    Data Count
    -0.023 1
    -0.095 2 1. Frequency Histogram
    -0.204 3
    0.004 4 70
    -0.063 5
    -0.079 6
    0.014 7 60
    -0.077 8
    0.067 9
    50
    0.059 10
    0.018 11
    0.043 12
    40
    0.062 13
    -0.035 14
    0.032 15
    30
    -0.023 16
    -0.057 17
    0.054 18
    20
    0.015 19
    0.019 20
    -0.088 21
    10
    -0.032 22
    0.044 23
    0
    1 2 3 4
    20

    10

    -0.089 24 0
    -0.021 25 1 2 3 4
    0.026 26
    -0.005 27
    -0.142 28
    0.007 29
    -0.045 30
    -0.056 31
    -0.014 32
    -0.182 33
    -0.032 34
    -0.034 35
    0.016 36
    -0.002 37
    0.011 38
    0.005 39
    -0.038 40
    0.011 41
    -0.035 42
    0.016 43
    -0.015 44
    -0.075 45
    -0.085 46
    -0.080 47
    -0.024 48
    0.000 49
    0.014 50
    -0.014 51
    0.013 52
    -0.057 53
    0.117 54
    -0.071 55
    -0.042 56
    -0.068 57
    -0.074 58
    0.041 59
    -0.091 60
    0.094 61
    -0.065 62
    0.021 63
    -0.076 64
    -0.020 65
    -0.034 66
    0.036 67
    -0.079 68
    0.012 69
    0.073 70
    -0.090 71
    -0.030 72
    0.069 73
    0.081 74
    0.033 75
    0.059 76
    0.162 77
    0.037 78
    0.028 79
    -0.098 80
    0.080 81
    -0.022 82
    0.026 83
    0.072 84
    0.018 85
    0.042 86
    -0.109 87
    -0.029 88
    0.085 89
    0.026 90
    -0.072 91
    0.011 92
    0.149 93
    -0.062 94
    0.042 95
    0.091 96
    -0.066 97
    -0.014 98
    0.072 99
    -0.035 100
    -0.061 101
    0.085 102
    0.023 103
    0.081 104
    0.037 105
    -0.143 106
    -0.065 107
    0.020 108
    0.012 109
    -0.002 110
    0.093 111
    -0.051 112
    -0.074 113
    -0.015 114
    0.077 115
    -0.016 116
    -0.086 117
    0.007 118
    0.060 119
    -0.053 120
    0.047 121
    0.061 122
    0.018 123
    0.001 124
    -0.033 125
    cy Histogram
    the range of values in the data
    frequency count
    1
    4
    58
    59
    3

    125 Total number of data points

    1. Frequency Histogram
    0.5

    0.45

    0.4

    0.35

    0.3
    Column H
    0.25

    0.2

    0.15

    0.1

    0.05

    0
    2 3 4 5 1
    0.1

    0.05

    0
    2 3 4 5 1
    2. Probability Histogram
    Bins cover same ranges dividing frequency by total gives
    from: to: "probability" of bin midpoint of bin
    Bin 1 -0.3 -0.2 0.008 -0.25
    Bin 2 -0.2 -0.1 0.032 -0.15
    Bin 3 -0.1 0 0.464 -0.05
    Bin 4 0 0.1 0.472 0.05
    Bin 5 0.1 0.2 0.024 0.15
    and probabilities sum to:
    1

    2. Probability Histogram

    Column

    1 2 3 4 5
    1 2 3 4 5
    Mean, variance, and skewness of data in

    -0.007 0.0040
    mean of data points variance of data points

    Column R

    5
    5
    e, and skewness of data inputs and the "probability histogram"
    midpoint of bin weighting of bin
    -0.25 0.008
    -0.15 0.032
    -0.05 0.464
    0.05 0.472
    0.15 0.024
    -0.1697 -0.0028
    skewness of data points mean of bins
    variance skewness
    0.0005 -0.0001
    0.0007 -0.0001
    0.0010 0.0000
    0.0013 0.0001
    0.0006 0.0001
    0.0041 -0.00012
    variance of bins skewness of bins

    You might also like