And Data Interpretation - Statistics Project Example

4BBY1060: Statistics and Data Interpretation This work is worth 10% of the module marks Using MS Word, or clear hand-writing, enter your answers to questions in the spaces provided. Insert all tables at the end of the document, making sure they are properly labelled and have appropriate legends. When complete, print the coursework and attach your CYO coversheet to the front (see the module booklet, p8 if you do not know how to do this). Also attach your hand-drawn histogram at the back, stapling everything together.

The submission deadline is 2:00 PM, 16th March. Guidance on the use of Excel can be found on the 4BBY1060 coursework tab. Part A (cardiovascular data) [total 20 marks]:The data is provided separately as an Excel spreadsheet entitled ‘cardiovascular data’ on the 4BBY1060 module website ‘coursework’ tab. It will show: systolic BP and diastolic BP taken from the same set of subjects either while supine or standing. Answer all parts of the question 1). What is the formula for calculating mean arterial blood pressure (MABP)?

[1 mark]2). Using Excel, calculate three new columns, giving for each subject their MABP supine and standing and their increase in MABP when standing rather than lying supine. From the new columns, again using Excel, calculate, for the whole class, and for males and females separately, the mean, SD and SEM for MABP for supine and standing positions and for the increase in MABP. You do not need to print your columns of raw data.Present all these summaries, including the numbers of subjects and units of measurement, in a single table.

It should also include a title and a legend which states briefly how the experimental data were obtained (i.e. summarises what was done in the practical). Round the values up to an appropriate number of decimal places. [4 marks]WHOLE CLASSSupine systolicSupine diastolicStanding systolicStanding DiastolicMABP SupineMABP standingMABP increaseMEAN119.806451669.6344086125.408602278.8387096886.3584229494.362007178.003584SD13.552841889.48544072715.2858534811.056466069.40156690611.05472297.232925SEM1.

4053642360.9835943841.5850691671.1465021220.9748970741.1463213640.750019FEMALEMEAN114.3669.34117.1476.384.3466666789.913333335.566667STDEV10.948413369.56099644711.290252259.7295048859.0111948529.0900783176.144979SEM1.5483394661.3521290851.5966827861.3759597761.2743753971.2855312040.869031FEMALEMEAN126.139534969.97674419135.023255881.7906976788.6976744299.5348837210.83721SD13.642687559.49809096613.6773855311.863425479.40528219110.969688777.433078SEM2.0804903471.4484452932.0857817391.8091554231.

4342920881.6728618541.1335343). Complement the numerical statistics with a graphical display: From the MABP increase values, construct a grouped frequency table for the whole class, showing the frequency and percentage frequency at 5 mmHg intervals. Remember that % values should add up to 100. Draw by hand the histogram. It is normal in biosciences for these to be plotted as percentage frequency, NOT % freq density. Remember to label the axes and intervals and include a title or legend so that the graph is readily understandable.

[4 marks] IntervalFrequencycumulative frequency0