How to show the critical difference (CD)/ least significant difference (LSD) in a chart
67
Researchers and Scientists usually need to show LSD within the graphics to explain the effect of different treatments. It is easier to show the standard errors in charts or graphs using Microsoft Excel program but difficult to show the LSD as program has options for standard error but not for LSD. If one represents the treatment difference and explains it with standard error it does not convey the exact meaning. LSD can be shown in a graph easily following few simple steps as shown below.
Step 1. Prepare the table and leave one row blank between treatments and LSD rows..
Step 2. Insert either a line or Bar diagram and select the data in the Microsoft Excel worksheet.
Step 3. In the blank row (between treatment and LSD row), put a value higher than the maximum data value shown for production. Here we placed 22 (Max. value=17.2)
Step 4. Click on the chart and select the data (Include the blank row which you have just filled with value 22. Chart will show straight line for this data series in straight line chart but a bar column in bar chart. Click on this data series and change bar chart to line chart.
Step 5. Now right click on the added line and click "format data series".
Now select "Y Error Bar" and select the custom button.
Now click in the blank space of "+" button enter the LSD vales for all the years and pree the enter button. Repeat the same for "-" button
Step 6. This is your last step. Right click on data series and select pattern.
Under the line menu, click "none" and also select "none" under the marker value.
This procedure is for Office 2003. You can show a bar column in place of line using Office 2007.
Looking X-mas gift under $130
|
iGo Stowaway Ultra-Slim Bluetooth Keyboard for Blackberry and other PDA/ Handhelds
Price: $149.99
List Price: $149.99 |
|
Logitech diNovo Edge Keyboard (Black)
Price: $134.88
List Price: $199.99 |
|
Palm 3245WW Wireless Bluetooth Keyboard
Price: $15.70
List Price: $77.99 |
|
Kinamax BT-KBRD Bluetooth Wireless Multimedia Slim Keyboard for Computers and Sony PS3 - Driverless
Price: $36.47
List Price: $39.96 |
|
Logitech diNovo Edge Mac Edition Cordless Keyboard
Price: $89.00
List Price: $159.99 |
|
Bluetooth Mini Kb with Touch Pad
Price: $79.99
List Price: $99.99 |
|
Matias Bluetooth Folding Keyboard for MAC
Price: $81.83
List Price: $99.95 |
|
Logitech PlayStation 3 Cordless MediaBoard Pro
Price: $67.17
List Price: $79.99 |
|
Wireless - Bluetooth Apple Wireless Keyboard White M...
Current Bid: $43.50
|
|
NEW Logitech diNovo Mini Bluetooth Wireless Keyboard
Current Bid: $119.99
|
|
Bluetooth Apple Wireless Keyboard, MB167LL/A As is
Current Bid: $9.00
|
|
Rocketfish Bluetooth Keyboard and Mouse
Current Bid: $20.50
|
|
Mini Bluetooth Wireless Keyboard for PC/PDA/Cell Phones
Current Bid: $17.99
|
|
Apple MB167LL/A Bluetooth Wireless Keyboard
Current Bid: $32.00
|
Other hubs of same author
- Cashew nut (Kaju): Traditional Medicinal Uses
Cashew or Kaju is a useful tree as different parts of it are used either individually or collectively to treat several diseases. Fresh or hot water extract of different plant parts is used orally as... - 3 days ago
- Onion (Allium cepa L.): Medicinal uses
Onion has numerous medicinal uses for treating diseases. Onion is used almost in all the medicinal systems. Different plant parts are used in various forms such as raw, hot or cold water extracts, fresh or... - 7 days ago
- Does money plant bring prosperity to our home
Scindapsus aureus is the scientific name of the money plant.Epipremnum aureum is also used as scientific name of the money plant by many and considered synonym of Scindapsus aureus. Besides money plant, other... - 2 weeks ago
- How to show the critical difference (CD)/ least significant difference (LSD) in a chart
Researchers and Scientists usually need to show LSD within the graphics to explain the effect of different treatments. It is easier to show the standard errors in charts or graphs using Microsoft Excel... - 3 weeks ago
- Participate in 'Health Quiz', Enrich Your Knowledge and stay Healthy
Have you heard the word "Hypothermia" before. No, OK, you will learn several new such terms after participating in the quiz. Do you know that corn or soya oil reduces not only bad cholesterol (LDL) but also... - 4 weeks ago
- How to make rice beer at home - The Indian Tribal Way
Hadia or Handia is the rice beer, made after fermentation of rice starch into sugars, in eastern Indian states of Jharkhand, Orissa and West Bengal. The leading wine manufacturers in India and elesewhere... - 4 weeks ago
- Indian Agriculture: An Overview
Contribution of agriculture and allied sector is about 22 percent in terms of Gross Domestic Product (GDP) of India. Importance of agriculture in India can be gauzed by the fact that 65-70 per cent of the... - 4 weeks ago
- Green Tea: Health benefits, side effects, precautions
We've heard that tea leaves steeped in boiling water are used by people to keep them healthy and physically fit. As science developed, people began to examine the advantages and disadvantages of drinking tea... - 5 weeks ago
PrintShare it! — Rate it: up down flag this hub
