Fruit & vegetables statistical analysis

[

[Name if the institution]

Fruit & vegetables statistical analysis

Introduction

This assignment is based on the statistical analysis of fruits and vegetables that how much fruit and vegetables are consumed by the different customers located in different cities. It also analyzes the percentage of damaged foods and the impact of the damaged food on the price of the products in different countries. This assignment critically analyzes the mean and sum of different fruits and vegetables that are damaged in different cities. The main variables that are used in this assignment are “price per kg of the vegetables and fruits” and “percentage of damaged produce”. Besides these variables, there are five other variables also; “ID number”, “customer”, “city”, “produce”, and “quantity sold per day”. However, the most important and significant variables for the study are “price per kg of the vegetables and fruits” and “percentage of damaged produce”. Between these variables, “price per kg of the vegetables and fruits” is a dependent variable, and “percentage of damaged produce” is an independent variable. The analysis shows that the price of the produce is highly dependent on the quantity and amount of damaged produce. In this assignment, a brief statistical analysis is carried out that shows the relationship between the independent variable (percentage of damaged produce) and dependent variable (price per kg of the vegetables and fruits). Moreover, this assignment shows that how much fruits and vegetables are consumed or purchased by the types of the customers that are; Coles, private, and Safeway.

The first part emphasize on the random data that is generated from the sample size of 350 customers. Next part emphasize on the amount of produce purchased by different customers. Moving to the next part, there is a brief discussion of the sum of percentage of damaged food and price per kg, which indicates that among all the fruits and vegetables, which vegetable and fruit has higher prices and lower prices and which vegetable and fruit holds more percentage of damaged produce. Next to this, T-Test is carried out that shows that how much purchasing at Coles took place. Moreover, a regression analysis is also carried out that shows the intensity of relationship and direction of relationship between the independent variable and dependent variable.

Discussion

Random Data in Ascending Order

The below mentioned data is the randomly generated data from the original data file. The following data is extracted from the sample size of 350 customers.

ID number

Customer

City

Produce

Quantity (sold/day)

Price $/kg

% of Produce Damage

80

1

2

3

529.41

0.36

7.92

42

1

2

2

11.10

2.99

1.13

68

1

1

3

321.88

1.25

5.25

327

3

2

4

360.72

1.53

8.41

218

3

1

1

177.78

2.31

4.07

211

2

2

4

85.31

2.34

4.58

74

1

2

3

396.38

0.81

7.07

63

1

1

3

337.18

1.04

5.88

3

1

1

1

235.31

1.88

5.36

186

2

1

4

478.02

1.90

7.30

307

3

1

4

461.12

1.09

9.73

120

2

2

1

305.48

2.05

4.85

17

1

2

1

140.02

2.72

3.04

145

2

2

2

344.16

0.94

7.18

104

2

1

1

182.03

2.28

4.16

313

3

1

4

82.03

2.05

5.62

261

3

2

2

83.06

2.29

3.23

329

3

2

4

118.80

2.29

4.76

127

2

2

1

162.50

2.50

3.70

157

2

1

3

318.86

1.29

5.13

154

2

1

3

396.85

1.57

4.79

165

2

2

3

342.91

1.38

5.36

132

2

1

2

135.82

2.76

1.82

229

3

1

1

104.44

2.58

3.46

272

3

2

2

331.46

1.12

6.64

227

3

1

1

111.50

2.51

3.67

30

1

1

2

346.85

1.57

5.29

194

2

1

4

5.00

2.28

4.79

286

3

1

3

344.85

0.93

6.21

183

2

1

4

381.38

1.42

8.74

160

2

1

3

356.88

0.75

6.75

140

2

2

2

35.82

2.76

1.82

197

2

1

4

16.03

2.62

3.57

33

1

1

2

323.28

1.85

4.45

182

2

1

4

461.12

1.65

8.05

318

3

1

4

42.45

2.45

4.18

86

1

1

4

95.95

2.88

2.63

112

2

1

1

69.82

2.91

2.47

190

2

1

4

18.00

2.82

2.85

54

1

2

2

275.88

1.82

4.54

116

2

2

1

350.09

1.53

6.41

178

2

2

3

502.84

0.73

6.81

87

1

1

4

9.00

2.96

2.34

20

1

2

1

188.77

2.23

4.51

133

2

1

2

72.61

3.33

0.11

136

2

1

2

364.28

1.35

5.95

222

3

1

1

154.48

2.47

3.59

303

3

2

3

523.45

0.45

7.65

128

2

2

1

145.21

2.67

3.19

320

3

2

4

404.24

1.59

8.23

Pivot table of produce and customers

Count of Customer

 

Produce

Total

1

13

2

11

3

11

4

15

(blank)

 

Grand Total

50

There are total four types of produce; orange, apple, potato, and tomato. Different customers have used different types of fruits and vegetables. The above pivot table shows that the high produce that customers used was of “Tomato” that holds an amount of fifteen. On the other hand, “apple” and “potato” showed the least produce.

Sum of Produce

 

 

Total

1

31

2

59

3

38

Grand Total

128



The pivot table shows the relationship between the customers and the produce purchased by them. Private customers used high produce than the Safeway and ...