Statistics and Data Interpretation Project Example | Topics and Well Written Essays - 250 words

And Data Interpretation - Statistics Project Example It will show: systolic BP and diastolic BP taken from the same set of subjects either while supine or standing. 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. 3). 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] 4). Perform a t-test to compare the two positions for the whole class with respect to mean arterial blood pressure. Are the differences significant? Marks will be deducted for not explaining your choice of test or your conclusions, for not showing your working or for serious errors in calculation. The data will be provided separately as an Excel spreadsheet entitled ‘renal data’ on the 4BBY1060 module website ‘Coursework’ tab. It will show: average urine flow rate over 120 min, and average urine osmolality over