Why Use Software for Data Analysis?

Manual calculations are time-consuming and prone to errors. Spreadsheet software like Microsoft Excel allows you to:

• Store large amounts of data systematically
• Perform calculations instantly using formulas
• Create visual charts to illustrate trends
• Edit and update data easily

Step-by-Step: Analysing Your Form Five Project Data

Step 1: Enter Your Data into Excel

Open a new Excel workbook and create columns for each variable you measured. For instance, if your project examined the relationship between advertising expenditure and sales volume for a local shop in Dar es Salaam, your table might look like this:

Step 2: Use Formulas to Calculate

Calculate totals, averages, and percentages using Excel formulas:

• Total: =SUM(B2:B13)
• Average: =AVERAGE(B2:B13)
• Percentage change: =(New Value - Old Value) / Old Value

Step 3: Create Charts to Visualise Trends

Highlight your data, then insert a chart. For economic data showing relationships between two variables, a scatter plot with a trend line is often appropriate. This helps you visually identify whether a positive, negative, or no relationship exists.

Step 4: Calculate Correlation (If Applicable)

If examining relationships between variables, use Excel's correlation function: =CORREL(array1, array2)

A result close to +1 indicates a strong positive relationship; close to -1 indicates a strong negative relationship; close to 0 indicates no relationship.

Your report should follow a standard structure that communicates your research clearly to the reader.

Recommended Report Structure

1. Title Page

   • Project title
   • Your name and index number
   • School name
   • Date

2. Abstract

   • A brief summary (100-150 words) of your research question, methods, key findings, and conclusions.

3. Introduction

   • Background to the problem
   • Statement of the research problem
   • Objectives of the study
   • Research questions or hypotheses

4. Literature Review

   • Brief discussion of economic theories relevant to your topic
   • Reference to findings from academic sources

5. Methodology

   • Research design (e.g., survey, case study)
   • Population and sample
   • Data collection methods
   • Data analysis methods

6. Presentation and Analysis of Findings

   • Tables and charts showing your data
   • Interpretation of results
   • Link findings to your research questions

7. Conclusions and Recommendations

   • Summary of key findings
   • Recommendations for stakeholders (e.g., business owners, policymakers)

8. References

   • List all sources cited in your report using a consistent format (APA or Harvard)

9. Appendices

   • Include questionnaires, raw data tables, or additional calculations

Worked Example: Report Section on Data Presentation

Suppose your project investigated the effect of price changes on demand for rice in Morogoro. In your findings section, you would present your data in a table, followed by interpretation:

Table 3: Price and Quantity Demanded of Rice (Morogoro Market, 2024)

Interpretation: The data shows an inverse relationship between price and quantity demanded, consistent with the law of demand. As price increased from TSh 1,800 to TSh 2,200 per kilogram, quantity demanded fell from 500 kg to 350 kg—a decrease of 30 percent. This confirms that rice in Morogoro follows the normal downward-sloping demand curve.

Presentation Tips

• Summarise your key findings in 5-7 slides if using PowerPoint
• Focus on the most important tables and charts
• Clearly explain what the data shows
• Connect your findings to economic theory
• Be prepared to answer questions about your methodology and conclusions

Discussion Session

During group discussion, expect to:

• Explain your research process
• Defend your methodology choices
• Compare your findings with economic theory
• Discuss limitations of your study
• Suggest areas for further research

Before submission, check the following:

• All sections are complete and properly formatted
• Tables and charts are clearly labelled with titles and sources
• Your analysis directly answers your research questions
• References are accurate and complete
• The report is free from grammatical errors
• You have included your raw data in the appendices

Completing an economics project report directly prepares you for real-world tasks in Tanzania. For example, if you later work as a market researcher for a telecom company in Arusha, you will collect data on customer spending, use Excel to analyse patterns (such as how airtime purchases vary with income), and write reports recommending new tariff packages. These skills are also essential for managing your own small business—tracking costs, calculating profits, and making data-driven decisions about pricing your products.