Excel Answers

6. PGA Golf Scores At a recent PGA tournament (the

Honda Classic at Palm Beach Gardens, Florida) the

following scores were posted for eight randomly

selected golfers for two consecutive days. At a 0.05,

is there evidence of a difference in mean scores for the

two days?

Golfer 12345678

Thursday 67 65 68 68 68 70 69 70

Friday 68 70 69 71 72 69 70 70

Drivers using the Accra-Tema motorway have to stop at the tollbooth to pay their tolls. Motorists arrive at the tollbooth at a rate of 200 per 8-hour-day. The single tollbooth attendant can serve, on average, 220 motorists per 8-hour-day.

i) What is the average minutes’ time a motorist waits in the queue to receive service at the toll?

ii) What is the average number of motorists in the queuing system?

iii) Management of the motorway likes to have its operators working 90% of the time. What must the arrival rate be for the tollbooth attendant to be as busy as management would like?

Productivity software (such as Excel or Google Sheets) is used by almost every business. Think in terms of your own field of study and future profession, in what ways could you use productivity software to increase efficiency in your work?

(b) Compute the Expected Value perfect Information (EVPI) and interpret it.

2. How would you summarize the performance of the students in the below data in excel? Use at least 5 of the functions from the relevant category of functions you have learnt in excel. 

Ram Age17 Scores85 A

Ravi Age16 Score 64 B

Roy Age15 Score91 A

Shubha Age17 Score 80 A

Reshma Age18 Score0 B 

(10 Marks)

The Unilever Company plans to allocate some or all of its monthly advertising budget of GH¢82,000 in the Mankato area. It can purchase local radio spots at GH¢120 per spot, local TV spots at GH¢600 per spot, and local newspaper advertising at GH¢220 per insertion.

The company's policy requirements specify that the company must spend at least GH¢40,000 on TV and allow monthly newspaper expenditures up to GH¢60,000.

Every facet of our lives has been affected by the COVID-19 pandemic. Citizens are encouraged to use online platforms at the expense of face-face-face interactions. With specific examples explain how information technology can be used in this challenging times in the following disciplines;

a) Education

b) Government

c) Health Care

d) Science and Engineering and

e) Banking and Finance

In two or more complete sentences, describe an activity you perform that has an impact on climate change? Is it positive or negative? Can it be adjusted to improve our climate? Justify your answers in two or more complete sentences. Write your answer in the essay box below.