Managing Data And Information

Managing Data And
Information
1

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
TASK A...........................................................................................................................................3
Excel worksheet that will represent the progress made related to the project through pasting
screenshots. The table should also retrieves price of “Peruvian” carpet.....................................3
TASK B...........................................................................................................................................5
1. Frequency and percentage frequency table related to each of the following variables...........5
2 Bar chart representing age........................................................................................................7
3 Descriptive statistic for variable “satisfaction”........................................................................7
5 Scatter diagram that represent information related to “satisfaction” and score against actual
time taken.....................................................................................................................................8
Calculation related to correlation coefficient and linear regression equation.............................8
TASK C...........................................................................................................................................9
1 Network diagram and forward and backward pass...................................................................9
2 Critical Path and its duration..................................................................................................10
3 Impact on project if the actual duration of activity A is of two weeks...................................11
TASK D.........................................................................................................................................11
1 The probability related to four or more room occupied on particular weekend night............11
2 P- value and its related calculation........................................................................................11
CONCLUSION..............................................................................................................................11
REFERENCES..............................................................................................................................12
2

INTRODUCTION
Managing data and information is stated to be an process that is used to store, analysis
and organised plenty of information, statistical facts and figure so that right decision can be taken
for growth and development of company. There are large amount of data and facts that company
store and utilised in order to plan strategies and delivered best services to customers. This report
has included four task that represent key information related to different scenario and activities
related to data and information management.
TASK A
Excel worksheet that will represent the progress made related to the project through
pasting screenshots. The table should also retrieves price of “Peruvian” carpet
Type of carpet Price (£)
Iranian 12000
Algerian 10000
Turkish 8000
Peruvian 15000
Uzbek 20000
Malian 14000
The excel sheet pertaining to the sales of Peruvian carpet can be illustrated through the following
table:
Type of carpet N° of units sold Price (£) Total (£)
Peruvian 2 15000 30000
Screenshots
3

4