Question

3. Fluorescence values of 4 different compounds (A, B, C and D) were measured (each in triplicate) and the results of each co

Can you please solve it in Excel? Also i cannot understand how i calculate all averages, s. deviations and result with just one function for every compound.(The problem that i cannot understood is explained in p.s. section)

0 0
Add a comment Improve this question Transcribed image text
Answer #1


C Result Mean Measurement Compound No. 1 Standard Deviation | Result(%) 42.33333333 | 1.527525232 | 35.33333333 2.516611478 ন

A)

Arithmetic mean of three different measurement of each compound can be calculated using function:

For Compound A: =AVERAGE(C2:C4)

For Compound B: =AVERAGE(C5:C7)

For Compound C: =AVERAGE(C8:C10)

For Compound D: =AVERAGE(C11:C13)

B)

Standard deviation of three different measurement of each compound can be calculated using function:

For Compound A: =STDEV(C2:C4)

For Compound B: =STDEV(C5:C7)

For Compound C: =STDEV(C8:C10)

For Compound D: =STDEV(C11:C13)

C)

Percentage Equivalent of the remaining result can be calculated as follows:

For A 2 =C3/$C$2*$F$2

For A 3 =C4/$C$2*$F$2

For B 1 =C5/$C$2*$F$2

For B 2 =C6/$C$2*$F$2

For B 3 =C7/$C$2*$F$2

For C 1 =C8/$C$2*$F$2

For C 2 =C9/$C$2*$F$2

For C 3 =C10/$C$2*$F$2

For D 1=C11/$C$2*$F$2

For D 2 =C12/$C$2*$F$2

For D 3 =C13/$C$2*$F$2

Add a comment
Know the answer?
Add Answer to:
Can you please solve it in Excel? Also i cannot understand how i calculate all averages,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • I need to find out Weight(kg), Mean, and SD But I cannot understand how to find...

    I need to find out Weight(kg), Mean, and SD But I cannot understand how to find numbers in Excel Please explain one by one like what I should put in excel for each category Weight(kg), Mean, and SD.. Please explain it easily.. Page zoM weight 1. Convert the player weights from pounds to kilograms using the conversion 2 20462 entering this data in column D of the sheet "PlayerWeights. the weights in kg are rounded to the nearest integer and...

  • please I need help with excel or matlab part. part 3 Lab 1 BASIC DATA PROCESSING...

    please I need help with excel or matlab part. part 3 Lab 1 BASIC DATA PROCESSING PRE-LAB ASSIGNMENT 1. Read the lab manual carefully so you know what you have to do when you walk into the lab. 2. In a lab, the resistance of a resistor was measured using 50 samples giving the following values: 119.95 (6), 121.32 (5), 119.57 (7), 117.43(1), 120.76 (15), 120.67 (1), 119.78 (8), 121.43(3), 121.82(1), and 118.47 (3) 2 Estimate the average value of...

  • IN EXCEL SO I CAN SEE THE FORMULAS USED. Open the Excel program Suppose we want...

    IN EXCEL SO I CAN SEE THE FORMULAS USED. Open the Excel program Suppose we want to know the standard normal distribution up to the given value. That is P(Z <a). Lets use Excel instead of the standard normal distribution table In cell A1 type mean. In cell B1 type 0. That means that we are letting mean be zero. click on cell A2 and type SD. In cell B2 type 1. That means that we are letting standard deviation...

  • how should i graph this? i have a macbook with excel and the directions my professor sent dont make sense Problems Here are the results of an investigation into the rate of photosynthesis in the p...

    how should i graph this? i have a macbook with excel and the directions my professor sent dont make sense Problems Here are the results of an investigation into the rate of photosynthesis in the pond weed Elodea. The number of bubbles given off in one minute was counted under different light intensities, and each measurement was repeated 5 times. Use Excel to calculate the means and 95% confidence limits of these results, then plot a graph of the mean...

  • Please do #8 and explain each step in simple terms so I can understand how to...

    Please do #8 and explain each step in simple terms so I can understand how to do it. Thank you! you did not know that the aistributioh Was bell-shapea 8) Hope got a 76 on her last test in Psychology. The mean grade was an 82 and the standard deviation was 4 grade points. When she challenged her friend to a computer game, she scored a 4300. The mean score is a 4750 with a standard deviation of 400 points....

  • I need help building this in excel. I cannot come up with the weighted averages. In...

    I need help building this in excel. I cannot come up with the weighted averages. In this project you are required to do the following 1. Create an Excel spreads heet that will be capable of calculating several Multidimensional Poverty Index (MPI). Data set is at the end of the document. Keep in mind that weighting is involved in determining the Multidimensional Poverty Index (MPI) Your Excel spreadsheet should contain the following: 1 Your name, course name and project name...

  • can i get help answering these questions please i do not understand how to solve them...

    can i get help answering these questions please i do not understand how to solve them im having trouble please. Question Hop The brand manager for a brand of toothpaste must plan a campaign designed to increase brand recognition. He wants to first determine the percentage of adults who have heard of the brand. How many adults must he survey in order to be 90% confident that his estimate is within seven percentage points of the true population percentage? Complete...

  • Please answer ALL parts of these questions and show all work. I will rate my answer....

    Please answer ALL parts of these questions and show all work. I will rate my answer. Thank you! . E. Questions Consider the cylinder case. The uncertainty in any one measurement of the density can be determined in the following way. (a) Take the instrumental limit of error associated with the Vernier calipers used to be one-half the least count or smallest measureable increment 8lVernier = 0.001 cm Assume the uncertainty in all linear measurements to be the same and...

  • *******Please show ALL WORK/FORMULAS IN EXCEL AND SEPARATE THE ANSWERS FOR A/B/C SO I CAN CLEARLY...

    *******Please show ALL WORK/FORMULAS IN EXCEL AND SEPARATE THE ANSWERS FOR A/B/C SO I CAN CLEARLY SEE THEM****** TAKE PICTURES OF FORMULAS IN EXCEL AND PASTE THEM HERE. SHOW WHERE EACH CORRESPONDING FORMULA BELONGS IN EACH CELL, ETC 1. Moving Average Model (please review spreadsheet model of Forecast 1.xlsx.) Given the annual sales (in $1000s) for a small business (See 1st worksheet in Assignment 2.xlsx), answer the following questions. Please use 2-period Moving Average method to forecast the sales in...

  • please show all steps so I can fully understand the process of how to solve. thank...

    please show all steps so I can fully understand the process of how to solve. thank you ! (16) It has been observed that 45% of young Canadians, under 25, play video games on a regular basis. You choose a random sample of 8 persons in this age group. 2. (2) What probability distribution would be used to calculate probabilities in this example? State the formula -you do not need to repeat the formula in later parts. (4) State the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT