Project : Customer Profit Statistics
Choodamani Subedi
9/4/2021
data <- read.csv('Customerprofit.csv')
data## Ship_Mode Profit Unit_Price Shipping_Cost Customer_Name
## 1 Regular Air -213.25 38.94 35.00 Muhammed MacIntyre
## 2 Delivery Truck 457.81 208.16 68.02 Barry French
## 3 Regular Air 46.71 8.69 2.99 Barry French
## 4 Regular Air 1198.97 195.99 3.99 Clay Rozendal
## 5 Regular Air -4.72 5.28 2.99 Claudia Miner
## 6 Regular Air 782.91 39.89 3.04 Neola Schneider
## 7 Regular Air 93.80 15.74 1.39 Allen Rosenblatt
## 8 Delivery Truck 440.72 100.98 26.22 Sylvia Foulston
## 9 Regular Air -481.04 100.98 69.00 Sylvia Foulston
## 10 Regular Air -11.68 65.99 5.26 Jim Radford
## 11 Regular Air 313.58 155.99 8.99 Jim Radford
## 12 Express Air 26.92 3.69 0.50 Carlos Soltero
## 13 Regular Air -5.77 4.71 0.70 Carlos Soltero
## 14 Regular Air -172.88 15.99 13.18 Carl Ludwig
## 15 Regular Air -144.55 4.89 4.93 Carl Ludwig
## 16 Regular Air 5.76 2.88 0.70 Don Miller
## 17 Regular Air 252.66 40.96 1.99 Jack Garza
## 18 Delivery Truck -1766.01 95.95 74.35 Julia West
## 19 Regular Air -236.27 3.89 74.35 Eugene Barchas
## 20 Delivery Truck 80.44 120.98 74.35 Eugene Barchas
## 21 Regular Air 118.94 500.98 74.35 Eugene Barchas
## 22 Delivery Truck 3424.22 500.98 74.35 Edward Hooks
## 23 Regular Air -213.25 38.94 74.35 Muhammed MacIntyre
## 24 Delivery Truck 457.81 208.16 74.35 Barry French
## 25 Regular Air 46.71 8.69 74.35 Barry French
## 26 Regular Air 1198.97 195.99 74.35 Clay Rozendal
## 27 Regular Air 2351.23 5.28 74.35 Claudia Miner
## 28 Regular Air 3503.50 39.89 74.35 Neola Schneider
## 29 Regular Air 4655.76 15.74 74.35 Allen Rosenblatt
## 30 Delivery Truck 5808.03 100.98 74.35 Sylvia Foulston
## 31 Regular Air 6960.29 100.98 74.35 Sylvia Foulston
## 32 Regular Air 8112.55 65.99 74.35 Jim Radford
## 33 Regular Air 9264.82 155.99 74.35 Jim Radford
## 34 Express Air 10417.08 3.69 74.35 Carlos Soltero
## 35 Regular Air 11569.34 4.71 74.35 Carlos Soltero
## 36 Regular Air 12721.61 15.99 74.35 Carl Ludwig
## 37 Regular Air 13873.87 4.89 74.35 Carl Ludwig
## 38 Regular Air 15026.13 2.88 74.35 Don Miller
## 39 Regular Air 16178.40 40.96 74.35 Jack Garza
## 40 Delivery Truck 17330.66 95.95 74.35 Julia West
## 41 Regular Air 18482.92 3.89 74.35 Eugene Barchas
## 42 Delivery Truck 19635.19 120.98 74.35 Eugene Barchas
## 43 Regular Air 20787.45 500.98 74.35 Eugene Barchas
## 44 Delivery Truck 21939.71 500.98 74.35 Edward Hooks
## 45 Regular Air 23091.98 38.94 74.35 Muhammed MacIntyre
## 46 Delivery Truck 24244.24 208.16 74.35 Barry French
## 47 Regular Air 25396.50 8.69 74.35 Barry French
## 48 Regular Air 26548.77 195.99 74.35 Clay Rozendal
## 49 Regular Air 27701.03 5.28 74.35 Claudia Miner
## 50 Regular Air 28853.30 39.89 74.35 Neola Schneider
## 51 Regular Air 30005.56 15.74 74.35 Allen Rosenblatt
## 52 Delivery Truck 31157.82 100.98 74.35 Sylvia Foulston
## 53 Regular Air 32310.09 100.98 74.35 Sylvia Foulston
## 54 Regular Air 33462.35 65.99 74.35 Jim Radford
## 55 Regular Air 34614.61 155.99 74.35 Jim Radford
## 56 Express Air 35766.88 3.69 74.35 Carlos Soltero
## 57 Regular Air 36919.14 4.71 74.35 Carlos Soltero
## 58 Regular Air 38071.40 15.99 74.35 Carl Ludwig
## 59 Regular Air 39223.67 4.89 74.35 Carl Ludwig
## 60 Regular Air 40375.93 2.88 74.35 Don Miller
## 61 Regular Air 41528.19 40.96 74.35 Jack Garza
## 62 Delivery Truck 42680.46 95.95 74.35 Julia West
## 63 Regular Air 43832.72 3.89 74.35 Eugene Barchas
## 64 Delivery Truck 44984.98 120.98 74.35 Eugene Barchas
## 65 Regular Air 46137.25 500.98 74.35 Eugene Barchas
## 66 Delivery Truck 47289.51 500.98 74.35 Edward Hooks
## 67 Regular Air 48441.77 38.94 74.35 Muhammed MacIntyre
## 68 Delivery Truck 49594.04 208.16 74.35 Barry French
## 69 Regular Air 50746.30 8.69 74.35 Barry French
## 70 Regular Air 51898.57 195.99 74.35 Clay Rozendal
## 71 Regular Air 53050.83 5.28 74.35 Claudia Miner
## 72 Regular Air 54203.09 39.89 74.35 Neola Schneider
## 73 Regular Air 55355.36 15.74 74.35 Allen Rosenblatt
## 74 Delivery Truck 56507.62 100.98 74.35 Sylvia Foulston
## 75 Regular Air 57659.88 100.98 74.35 Sylvia Foulston
## 76 Regular Air 58812.15 65.99 74.35 Jim Radford
## 77 Regular Air 59964.41 155.99 74.35 Jim Radford
## 78 Express Air 61116.67 3.69 74.35 Carlos Soltero
## 79 Regular Air 62268.94 4.71 74.35 Carlos Soltero
## 80 Regular Air 63421.20 15.99 74.35 Carl Ludwig
## 81 Regular Air 64573.46 4.89 74.35 Carl Ludwig
## 82 Regular Air 65725.73 2.88 74.35 Don Miller
## 83 Regular Air 66877.99 40.96 74.35 Jack Garza
## 84 Delivery Truck 68030.25 95.95 74.35 Julia West
## 85 Regular Air 69182.52 3.89 74.35 Eugene Barchas
## 86 Delivery Truck 70334.78 120.98 74.35 Eugene Barchas
## 87 Regular Air 71487.04 500.98 74.35 Eugene Barchas
## 88 Delivery Truck 72639.31 500.98 74.35 Edward Hooks
## 89 Regular Air 73791.57 38.94 74.35 Muhammed MacIntyre
## 90 Delivery Truck 74943.84 208.16 74.35 Barry French
## 91 Regular Air 76096.10 8.69 74.35 Barry French
## 92 Regular Air 77248.36 195.99 74.35 Clay Rozendal
## 93 Regular Air 78400.63 5.28 74.35 Claudia Miner
## 94 Regular Air 79552.89 39.89 74.35 Neola Schneider
## 95 Regular Air 80705.15 15.74 74.35 Allen Rosenblatt
## 96 Delivery Truck 81857.42 100.98 74.35 Sylvia Foulston
## 97 Regular Air 83009.68 100.98 74.35 Sylvia Foulston
## 98 Regular Air 84161.94 65.99 74.35 Jim Radford
## 99 Regular Air 85314.21 155.99 74.35 Jim Radford
## 100 Express Air 86466.47 3.69 74.35 Carlos Soltero
## 101 Regular Air 87618.73 4.71 74.35 Carlos Soltero
## 102 Regular Air 88771.00 15.99 74.35 Carl Ludwig
## 103 Regular Air 89923.26 4.89 74.35 Carl Ludwig
## 104 Regular Air 91075.52 2.88 74.35 Don Miller
## 105 Regular Air 92227.79 40.96 74.35 Jack Garza
## 106 Delivery Truck 93380.05 95.95 74.35 Julia West
## 107 Regular Air 94532.31 3.89 74.35 Eugene Barchas
## 108 Delivery Truck 95684.58 120.98 74.35 Eugene Barchas
## 109 Regular Air 96836.84 500.98 74.35 Eugene Barchas
## 110 Delivery Truck 97989.11 500.98 74.35 Edward Hooks
## 111 Regular Air 99141.37 38.94 74.35 Muhammed MacIntyre
## 112 Delivery Truck 100293.63 208.16 74.35 Barry French
## 113 Regular Air 101445.90 8.69 74.35 Barry French
## 114 Regular Air 102598.16 195.99 74.35 Clay Rozendal
## 115 Regular Air 103750.42 5.28 74.35 Claudia Miner
## 116 Regular Air 104902.69 39.89 74.35 Neola Schneider
## 117 Regular Air 106054.95 15.74 74.35 Allen Rosenblatt
## 118 Delivery Truck 107207.21 100.98 74.35 Sylvia Foulston
## 119 Regular Air 108359.48 100.98 74.35 Sylvia Foulston
## 120 Regular Air 109511.74 65.99 74.35 Jim Radford
## 121 Regular Air 110664.00 155.99 74.35 Jim Radford
## 122 Express Air 111816.27 3.69 74.35 Carlos Soltero
## 123 Regular Air 112968.53 4.71 74.35 Carlos Soltero
## 124 Regular Air 114120.79 15.99 74.35 Carl Ludwig
## 125 Regular Air 115273.06 4.89 74.35 Carl Ludwig
## 126 Regular Air 116425.32 2.88 74.35 Don Miller
## 127 Regular Air 117577.58 40.96 74.35 Jack Garza
## 128 Delivery Truck 118729.85 95.95 74.35 Julia West
## 129 Regular Air 119882.11 3.89 74.35 Eugene Barchas
## 130 Delivery Truck 121034.38 120.98 74.35 Eugene Barchas
## 131 Regular Air 122186.64 500.98 74.35 Eugene Barchas
## 132 Delivery Truck 123338.90 500.98 74.35 Edward Hooks
## 133 Regular Air 124491.17 38.94 74.35 Muhammed MacIntyre
## 134 Delivery Truck 125643.43 208.16 74.35 Barry French
## 135 Regular Air 126795.69 8.69 74.35 Barry French
## 136 Regular Air 127947.96 195.99 74.35 Clay Rozendal
## 137 Regular Air 129100.22 5.28 74.35 Claudia Miner
## 138 Regular Air 130252.48 39.89 74.35 Neola Schneider
## 139 Regular Air 131404.75 15.74 74.35 Allen Rosenblatt
## 140 Delivery Truck 132557.01 100.98 74.35 Sylvia Foulston
## 141 Regular Air 133709.27 100.98 74.35 Sylvia Foulston
## 142 Regular Air 134861.54 65.99 74.35 Jim Radford
## 143 Regular Air 136013.80 155.99 74.35 Jim Radford
## 144 Express Air 137166.06 3.69 74.35 Carlos Soltero
## 145 Regular Air 138318.33 4.71 74.35 Carlos Soltero
## 146 Regular Air 139470.59 15.99 74.35 Carl Ludwig
## 147 Regular Air 140622.85 4.89 74.35 Carl Ludwig
## 148 Regular Air 141775.12 2.88 74.35 Don Miller
## 149 Regular Air 142927.38 40.96 74.35 Jack Garza
## 150 Delivery Truck 144079.65 95.95 74.35 Julia West
## 151 Regular Air 145231.91 3.89 74.35 Eugene Barchas
## 152 Delivery Truck 146384.17 120.98 74.35 Eugene Barchas
## 153 Regular Air 147536.44 500.98 74.35 Eugene Barchas
## 154 Delivery Truck 148688.70 500.98 74.35 Edward Hooks
## 155 Regular Air 149840.96 38.94 74.35 Muhammed MacIntyre
## 156 Delivery Truck 150993.23 208.16 74.35 Barry French
## 157 Regular Air 152145.49 8.69 74.35 Barry French
## 158 Regular Air 153297.75 195.99 74.35 Clay Rozendal
## 159 Regular Air 154450.02 5.28 74.35 Claudia Miner
## 160 Regular Air 155602.28 39.89 74.35 Neola Schneider
## 161 Regular Air 156754.54 15.74 74.35 Allen Rosenblatt
## 162 Delivery Truck 157906.81 100.98 74.35 Sylvia Foulston
## 163 Regular Air 159059.07 100.98 74.35 Sylvia Foulston
## 164 Regular Air 160211.33 65.99 74.35 Jim Radford
## 165 Regular Air 161363.60 155.99 74.35 Jim Radford
## 166 Express Air 162515.86 3.69 74.35 Carlos Soltero
## 167 Regular Air 163668.12 4.71 74.35 Carlos Soltero
## 168 Regular Air 164820.39 15.99 74.35 Carl Ludwig
## 169 Regular Air 165972.65 4.89 74.35 Carl Ludwig
## 170 Regular Air 167124.92 2.88 74.35 Don Miller
## 171 Regular Air 168277.18 40.96 74.35 Jack Garza
## 172 Delivery Truck 169429.44 95.95 74.35 Julia West
## 173 Regular Air 170581.71 3.89 74.35 Eugene Barchas
## 174 Delivery Truck 171733.97 120.98 74.35 Eugene Barchas
## 175 Regular Air 172886.23 500.98 74.35 Eugene Barchas
## 176 Delivery Truck 174038.50 500.98 74.35 Edward Hooks
## 177 Regular Air 175190.76 38.94 74.35 Muhammed MacIntyre
## 178 Delivery Truck 176343.02 208.16 74.35 Barry French
## 179 Regular Air 177495.29 8.69 74.35 Barry French
## 180 Regular Air 178647.55 195.99 74.35 Clay Rozendal
## 181 Regular Air 179799.81 5.28 74.35 Claudia Miner
## 182 Regular Air 180952.08 39.89 74.35 Neola Schneider
## 183 Regular Air 182104.34 15.74 74.35 Allen Rosenblatt
## 184 Delivery Truck 183256.60 100.98 74.35 Sylvia Foulston
## 185 Regular Air 184408.87 100.98 74.35 Sylvia Foulston
## 186 Regular Air 185561.13 65.99 74.35 Jim Radford
## 187 Regular Air 186713.39 155.99 74.35 Jim Radford
## 188 Express Air 187865.66 3.69 74.35 Carlos Soltero
## 189 Regular Air 189017.92 4.71 74.35 Carlos Soltero
## 190 Regular Air 190170.19 15.99 74.35 Carl Ludwig
## 191 Regular Air 191322.45 4.89 74.35 Carl Ludwig
## 192 Regular Air 192474.71 2.88 74.35 Don Miller
## 193 Regular Air 193626.98 40.96 74.35 Jack Garza
## 194 Delivery Truck 194779.24 95.95 74.35 Julia West
## 195 Regular Air 195931.50 3.89 74.35 Eugene Barchas
## 196 Delivery Truck 197083.77 120.98 74.35 Eugene Barchas
## 197 Regular Air 198236.03 500.98 74.35 Eugene Barchas
## 198 Delivery Truck 199388.29 500.98 74.35 Edward Hooks
## 199 Regular Air 200540.56 38.94 74.35 Muhammed MacIntyre
## 200 Delivery Truck 201692.82 208.16 74.35 Barry French
## 201 Regular Air 202845.08 8.69 74.35 Barry French
## 202 Regular Air 203997.35 195.99 74.35 Clay Rozendal
## 203 Regular Air 205149.61 5.28 74.35 Claudia Miner
## 204 Regular Air 206301.87 39.89 74.35 Neola Schneider
## 205 Regular Air 207454.14 15.74 74.35 Allen Rosenblatt
## 206 Delivery Truck 208606.40 100.98 74.35 Sylvia Foulston
## 207 Regular Air 209758.66 100.98 74.35 Sylvia Foulston
## 208 Regular Air 210910.93 65.99 74.35 Jim Radford
## 209 Regular Air 212063.19 155.99 74.35 Jim Radford
## 210 Express Air 213215.46 3.69 74.35 Carlos Soltero
## 211 Regular Air 214367.72 4.71 74.35 Carlos Soltero
## 212 Regular Air 215519.98 15.99 74.35 Carl Ludwig
## 213 Regular Air 216672.25 4.89 74.35 Carl Ludwig
## 214 Regular Air 217824.51 2.88 74.35 Don Miller
## 215 Regular Air 218976.77 40.96 74.35 Jack Garza
## 216 Delivery Truck 220129.04 95.95 74.35 Julia West
## 217 Regular Air 221281.30 3.89 74.35 Eugene Barchas
## 218 Delivery Truck 222433.56 120.98 74.35 Eugene Barchas
## 219 Regular Air 223585.83 500.98 74.35 Eugene Barchas
## 220 Delivery Truck 224738.09 500.98 74.35 Edward Hooks
## 221 Regular Air 225890.35 38.94 74.35 Muhammed MacIntyre
## 222 Delivery Truck 227042.62 208.16 74.35 Barry French
## 223 Regular Air 228194.88 8.69 74.35 Barry French
## 224 Regular Air 229347.14 195.99 74.35 Clay Rozendal
## 225 Regular Air 230499.41 5.28 74.35 Claudia Miner
## 226 Regular Air 231651.67 39.89 74.35 Neola Schneider
## 227 Regular Air 232803.93 15.74 74.35 Allen Rosenblatt
## 228 Delivery Truck 233956.20 100.98 74.35 Sylvia Foulston
## 229 Regular Air 235108.46 100.98 74.35 Sylvia Foulston
## 230 Regular Air 236260.73 65.99 74.35 Jim Radford
## 231 Regular Air 237412.99 155.99 74.35 Jim Radford
## 232 Express Air 238565.25 3.69 74.35 Carlos Soltero
## 233 Regular Air 239717.52 4.71 74.35 Carlos Soltero
## 234 Regular Air 240869.78 15.99 74.35 Carl Ludwig
## 235 Regular Air 242022.04 4.89 74.35 Carl Ludwig
## 236 Regular Air 243174.31 2.88 74.35 Don Miller
## 237 Regular Air 244326.57 40.96 74.35 Jack Garza
## 238 Delivery Truck 245478.83 95.95 74.35 Julia West
## 239 Regular Air 246631.10 3.89 74.35 Eugene Barchas
## 240 Delivery Truck 247783.36 120.98 74.35 Eugene Barchas
## 241 Regular Air 248935.62 500.98 74.35 Eugene Barchas
## 242 Delivery Truck 250087.89 500.98 74.35 Edward Hooks
## 243 Regular Air 251240.15 38.94 74.35 Muhammed MacIntyre
## 244 Delivery Truck 252392.41 208.16 74.35 Barry French
## 245 Regular Air 253544.68 8.69 74.35 Barry French
## 246 Regular Air 254696.94 195.99 74.35 Clay Rozendal
## 247 Regular Air 255849.20 5.28 74.35 Claudia Miner
## 248 Regular Air 257001.47 39.89 74.35 Neola Schneider
## 249 Regular Air 258153.73 15.74 74.35 Allen Rosenblatt
## 250 Delivery Truck 259306.00 100.98 74.35 Sylvia Foulston
## 251 Regular Air 260458.26 100.98 74.35 Sylvia Foulston
## 252 Regular Air 261610.52 65.99 74.35 Jim Radford
## 253 Regular Air 262762.79 155.99 74.35 Jim Radford
## 254 Express Air 263915.05 3.69 74.35 Carlos Soltero
## 255 Regular Air 265067.31 4.71 74.35 Carlos Soltero
## 256 Regular Air 266219.58 15.99 74.35 Carl Ludwig
## 257 Regular Air 267371.84 4.89 74.35 Carl Ludwig
## 258 Regular Air 268524.10 2.88 74.35 Don Miller
## 259 Regular Air 269676.37 40.96 74.35 Jack Garza
## 260 Delivery Truck 270828.63 95.95 74.35 Julia West
## 261 Regular Air 271980.89 3.89 74.35 Eugene Barchas
## 262 Delivery Truck 273133.16 120.98 74.35 Eugene Barchas
## 263 Regular Air 274285.42 500.98 74.35 Eugene Barchas
## 264 Delivery Truck 275437.68 500.98 74.35 Edward HooksMean, SD and summary
mean(data$Profit)## [1] 125237var(data$Unit_Price)## [1] 19872.99sd(data$Profit)## [1] 85938.22summary(data$Profit, digits = 5)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## -1766 48154 123920 125240 199680 275440Histogram, Boxplot and QQ-Plot
hist(data$Profit)
boxplot(data$Profit)
qqnorm(data$Profit)
qqline(data$Profit)
Are there any outliers? No
Is the distribution normal, symmetric, skewed, or some other shape? Normal
table(data$Ship_Mode, data$Customer_Name)##
## Allen Rosenblatt Barry French Carl Ludwig Carlos Soltero
## Delivery Truck 0 12 0 0
## Express Air 0 0 0 12
## Regular Air 12 12 24 12
##
## Claudia Miner Clay Rozendal Don Miller Edward Hooks
## Delivery Truck 0 0 0 12
## Express Air 0 0 0 0
## Regular Air 12 12 12 0
##
## Eugene Barchas Jack Garza Jim Radford Julia West
## Delivery Truck 12 0 0 12
## Express Air 0 0 0 0
## Regular Air 24 12 24 0
##
## Muhammed MacIntyre Neola Schneider Sylvia Foulston
## Delivery Truck 0 0 12
## Express Air 0 0 0
## Regular Air 12 12 12Frequency & Relative Frequency
freq <- rbind(table(data$Profit),table(data$Shipping_Cost))## Warning in rbind(table(data$Profit), table(data$Shipping_Cost)): number of
## columns of result is not a multiple of vector length (arg 2)row.names(freq)<-c('Frequency','Relative Frequency')
freq## -1766.01 -481.04 -236.27 -213.25 -172.88 -144.55 -11.68
## Frequency 1 1 1 2 1 1 1
## Relative Frequency 1 2 1 1 2 1 1
## -5.77 -4.72 5.76 26.92 46.71 80.44 93.8 118.94 252.66 313.58
## Frequency 1 1 1 1 2 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1 1 1 247 1
## 440.72 457.81 782.91 1198.97 2351.23 3424.22 3503.5 4655.76
## Frequency 1 2 1 2 1 1 1 1
## Relative Frequency 2 1 1 2 1 1 1 1
## 5808.03 6960.29 8112.55 9264.82 10417.08 11569.34 12721.61
## Frequency 1 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1 247
## 13873.87 15026.13 16178.4 17330.66 18482.92 19635.19
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 2 1 1 2 1
## 20787.45 21939.71 23091.98 24244.24 25396.5 26548.77
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 27701.03 28853.3 30005.56 31157.82 32310.09 33462.35
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 247 1 2
## 34614.61 35766.88 36919.14 38071.4 39223.67 40375.93
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 2 1 1 1
## 41528.19 42680.46 43832.72 44984.98 46137.25 47289.51
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 48441.77 49594.04 50746.3 51898.57 53050.83 54203.09
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 247 1 2 1 1
## 55355.36 56507.62 57659.88 58812.15 59964.41 61116.67
## Frequency 1 1 1 1 1 1
## Relative Frequency 2 1 1 1 1 1
## 62268.94 63421.2 64573.46 65725.73 66877.99 68030.25
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 247
## 69182.52 70334.78 71487.04 72639.31 73791.57 74943.84
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 2 1 1 2 1
## 76096.1 77248.36 78400.63 79552.89 80705.15 81857.42
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 83009.68 84161.94 85314.21 86466.47 87618.73 88771 89923.26
## Frequency 1 1 1 1 1 1 1
## Relative Frequency 1 1 1 247 1 2 1
## 91075.52 92227.79 93380.05 94532.31 95684.58 96836.84
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 2 1 1 1 1
## 97989.11 99141.37 100293.63 101445.9 102598.16 103750.42
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 104902.69 106054.95 107207.21 108359.48 109511.74 110664
## Frequency 1 1 1 1 1 1
## Relative Frequency 247 1 2 1 1 2
## 111816.27 112968.53 114120.79 115273.06 116425.32 117577.58
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 118729.85 119882.11 121034.38 122186.64 123338.9 124491.17
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 247 1
## 125643.43 126795.69 127947.96 129100.22 130252.48 131404.75
## Frequency 1 1 1 1 1 1
## Relative Frequency 2 1 1 2 1 1
## 132557.01 133709.27 134861.54 136013.8 137166.06 138318.33
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 139470.59 140622.85 141775.12 142927.38 144079.65 145231.91
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 247 1 2 1
## 146384.17 147536.44 148688.7 149840.96 150993.23 152145.49
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 2 1 1 1 1
## 153297.75 154450.02 155602.28 156754.54 157906.81 159059.07
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 160211.33 161363.6 162515.86 163668.12 164820.39 165972.65
## Frequency 1 1 1 1 1 1
## Relative Frequency 247 1 2 1 1 2
## 167124.92 168277.18 169429.44 170581.71 171733.97 172886.23
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 174038.5 175190.76 176343.02 177495.29 178647.55 179799.81
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 247 1
## 180952.08 182104.34 183256.6 184408.87 185561.13 186713.39
## Frequency 1 1 1 1 1 1
## Relative Frequency 2 1 1 2 1 1
## 187865.66 189017.92 190170.19 191322.45 192474.71 193626.98
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 194779.24 195931.5 197083.77 198236.03 199388.29 200540.56
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 247 1 2 1
## 201692.82 202845.08 203997.35 205149.61 206301.87 207454.14
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 2 1 1 1 1
## 208606.4 209758.66 210910.93 212063.19 213215.46 214367.72
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 215519.98 216672.25 217824.51 218976.77 220129.04 221281.3
## Frequency 1 1 1 1 1 1
## Relative Frequency 247 1 2 1 1 2
## 222433.56 223585.83 224738.09 225890.35 227042.62 228194.88
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 229347.14 230499.41 231651.67 232803.93 233956.2 235108.46
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 247 1
## 236260.73 237412.99 238565.25 239717.52 240869.78 242022.04
## Frequency 1 1 1 1 1 1
## Relative Frequency 2 1 1 2 1 1
## 243174.31 244326.57 245478.83 246631.1 247783.36 248935.62
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 250087.89 251240.15 252392.41 253544.68 254696.94 255849.2
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 247 1 2 1
## 257001.47 258153.73 259306 260458.26 261610.52 262762.79
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 2 1 1 1 1
## 263915.05 265067.31 266219.58 267371.84 268524.1 269676.37
## Frequency 1 1 1 1 1 1
## Relative Frequency 1 1 1 1 1 1
## 270828.63 271980.89 273133.16 274285.42 275437.68
## Frequency 1 1 1 1 1
## Relative Frequency 247 1 2 1 1**c) Include a two-way table for two of the categorical variables and discuss any relevant proportions. Describe any possible relationship between the two variables.
Answer:**
There is an association between absolute frequency table and relative frequency table. These are called bivariate associations. Summarize the linear relationship. Calculate the correlation. It is used more widely, more sensitive to errors and discrepancies in data.
**3. Preform hypothesis test
- Using the appropriate statistical test, preform a hypothesis test comparing a mean to a fixed value. Make certain to properly state your null and alternative hypothesis. State your conclusion in the correct statistical language. Answer:**
t.test(data$Profit)##
## One Sample t-test
##
## data: data$Profit
## t = 23.678, df = 263, p-value < 2.2e-16
## alternative hypothesis: true mean is not equal to 0
## 95 percent confidence interval:
## 114822.6 135651.5
## sample estimates:
## mean of x
## 125237Null and alternative hypothesis are two mutually exclusive statements about the profit of customer and display the mean value 125237.
**Null hypothesis (H0):The null hypothesis is an argument that is often made based on prior analyses or advanced expertise. H0: μ = m0
**Alternative Hypothesis (H1): The alternate hypothesis is what we expect or wish to prove to be right. H1: μ = m1
**Conclusion:
H0: μ = m0 and H1: μ = m1 are the hypotheses for this test and the P-value is the significance amount.
**(b) Using the appropriate statistical test, preform a hypothesis test comparing two means. Make certain to properly state your null and alternative hypothesis. State your conclusion in the correct statistical language.
Answer:
x <- data$Profit
y <- data$Shipping_Cost
t.test(x,y)##
## Welch Two Sample t-test
##
## data: x and y
## t = 23.665, df = 263, p-value < 2.2e-16
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
## 114752.1 135581.0
## sample estimates:
## mean of x mean of y
## 125237.04117 70.50508Null hypothesis is H0, it has “no effect” and “no difference”. H0: μ1 – μ2 = 0, which is same as H0: μ1 = μ2 Alternative hypothesis. H1: μ1 – μ2 < 0, which is same as H1: μ1 < μ2 H1: μ1 – μ2 > 0, which is same as H1: μ1 > μ2 H1: μ1 – μ2 ≠ 0, which is same as H1: μ1 ≠ μ2
Conclusion: H0: μ1 – μ2 = 0 and H1: μ1 – μ2 > 0 are the hypotheses for this test. We reject H0 and accept H1 since the P-value is smaller significance amount 125237.04117.
- Introduce your data set including a reference to where it can be found. Describe all relevant variables that you will use in your analysis.
Answer:
I have downloaded the “Customer Profit data file” and sorted data by four rows (Ship_Mode, Profit Unit_Price, Shipping_Cost and Customer_Name).
In this file data fields are representing customer profit, shipping mode, shipping cost and customer name in details.
Include all items requested above. Include graphs and text about each.
Answer:
All statistics data, graph and relationship I have explained above in details.
Write a brief conclusion highlighting the most interesting features of your data.
Answer:
This file contains the customer profit, shipping mode, shipping cost and customer name stats. It contains more detail data. From the statistical analysis I can conclude the history of the customer and profit. Interesting part is from the data stats I can choose top 10 customers and can share some gift with them or can refer for future purpose.