Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Using Microsoft Excel - Research and Teaching Methods - Lab, Study notes of Research Methodology

Indian Institute of Space Science and TechnologyResearch Methodology

The goal of this course is to pass on to new graduate students fundamentals of graduate research with an emphasis on biological systems engineering, and, college instruction. Keywords in this lab manual are: Using Microsoft Excel, Visual Basic for Application, Data Analysis, Charts Functions, Split and Freeze Panes Function, Graduate Research Summary, Probability of Occurrence

Typology: Study notes

2012/2013

Uploaded on 10/03/2013

abani
abani 🇮🇳

4.4

(34)

81 documents

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Using Microsoft Excel
Microsoft Excel is a powerful spreadsheet that is easy to use and allows you to store, manipulate, analyze
and visualize data. The basic functions of Excel include the follows.
• Copy & paste makes it easy for entering and manipulating data.
• Writing and replicating formula is straightforward and results are automatically updated after the
data used in the formula is changed.
• There are numerous built-in mathematic functions.
• The Charts functions have a multitude of options that are handy and easy to use.
• The embedded Visual Basic for Application (VBA) is powerful for data analysis.
The following tips should also be helpful.
• Use the relative ($+column number+row number—the default) and absolute address mode
($+column number+$+row number) as needed.
• Use the sheet address in combination with the relative address within a sheet, e.g., Sheet1!A1.
• Use the combination of “Shift”, “End” and an arrow key to quickly move to the end of the data in
a row or column or both.
• Export data in different formats based on your needs. The plain text or space delimited format
(extension “.prn”) is among the most commonly used. Similarly, Excel can import data in various
formats such as plain text.
• The Edit/Fill/Series function is very useful.
• The Data/Sort function performs data sorting (ascending; descending) effortlessly.
• The Data/Text to Column function lets you separate texts into columns.
• The Split and Freeze Panes function under Window allows you to view and compare data easily.
• Excel allows multiple data formats.
• The Goal Seek tool is convenient for solving equations.
Lab 1 Assignment
1. Excel Exercise
The ultimate goal of this exercise is to obtain a relationship between return period vs. annual peak stream
flow. Specifically, you will
1. Prepare the 1928–1959 annual peak discharge q data.
2. Rank the data in descending form.
3. Calculate the percent annual probability of occurrence where n is the rank of each
event, N is the total number of events. Note the unit of Fa is then % yr!1.
4. Calculate the return period . What is the unit of T ?
5. Plot T vs. q, fit a trend line and record R2.
6. Calculate log T and log q. Plot log T and log q, fit a trend line, and obtain R2. Compare the two
relationships you obtained and discuss about their statistical and physical meaning. (20 pts)
2. Graduate Research Summary
Develop a half-page essay describing (1) your graduate research goal and specific objectives; (2)
implication and applicability of the research; (3) anticipated results; and (4) major challenges. (5 pts)

Partial preview of the text

Download Using Microsoft Excel - Research and Teaching Methods - Lab and more Study notes Research Methodology in PDF only on Docsity!

Using Microsoft Excel

Microsoft Excel is a powerful spreadsheet that is easy to use and allows you to store, manipulate, analyze and visualize data. The basic functions of Excel include the follows.

  • Copy & paste makes it easy for entering and manipulating data.
  • Writing and replicating formula is straightforward and results are automatically updated after the data used in the formula is changed.
  • There are numerous built-in mathematic functions.
  • The Charts functions have a multitude of options that are handy and easy to use.
  • The embedded Visual Basic for Application (VBA) is powerful for data analysis.

The following tips should also be helpful.

  • Use the relative ($+column number+row number—the default) and absolute address mode ($+column number+$+row number) as needed.
  • Use the sheet address in combination with the relative address within a sheet, e.g., Sheet1!A1.
  • Use the combination of “Shift”, “End” and an arrow key to quickly move to the end of the data in a row or column or both.
  • Export data in different formats based on your needs. The plain text or space delimited format (extension “.prn”) is among the most commonly used. Similarly, Excel can import data in various formats such as plain text.
  • The Edit/Fill/Series function is very useful.
  • The Data/Sort function performs data sorting (ascending; descending) effortlessly.
  • The Data/Text to Column function lets you separate texts into columns.
  • The Split and Freeze Panes function under Window allows you to view and compare data easily.
  • Excel allows multiple data formats.
  • The Goal Seek tool is convenient for solving equations.

Lab 1 Assignment

1. Excel Exercise The ultimate goal of this exercise is to obtain a relationship between return period vs. annual peak stream flow. Specifically, you will 1. Prepare the 1928–1959 annual peak discharge q data. 2. Rank the data in descending form. 3. Calculate the percent annual probability of occurrence where n is the rank of each

event, N is the total number of events. Note the unit of Fa is then % yr!^1.

  1. Calculate the return period. What is the unit of T?
  2. Plot T vs. q , fit a trend line and record R^2.
  3. Calculate log T and log q. Plot log T and log q , fit a trend line, and obtain R^2. Compare the two relationships you obtained and discuss about their statistical and physical meaning. ( 20 pts ) 2. Graduate Research Summary Develop a half-page essay describing (1) your graduate research goal and specific objectives; (2) implication and applicability of the research; (3) anticipated results; and (4) major challenges. ( 5 pts )