Summary  
This chapter shows how to import numerical and text data from a spreadsheet into variables using readmatrix/readcell, perform calculations on that data in code, and export both results and labels back to the spreadsheet with writematrix/writecell.  

General domain of usage  
Data analysis and reporting

No one enters **large data sets** manually into **Matlab**, we **import** them! **Matlab** makes **importing** and **exporting Excel data** very simple, and we'll learn how to fill in a few parameters in a single line of **code** so that we can start **importing** and **exporting data** with **Matlab** and start solving **real world problems** with **programming**.

### Task
Write a program that:
- **Imports** the chapter **Excel file** (`data sample.xlsx`);  
- Calculates the **average number** of each **animal type**;  
- Calculates the **average species population** on each **farm**;  
- **Exports** the two sets of **averages** back to the **Excel file** in a location that makes sense;  
- **Exports** **headings** to the **Excel file** to label the sets of **averages** calculated.

Matlab's simplicity, efficiency, and overall computing power make it an excellent programming language for both beginners and top professionals alike. It's the language of choice for anything to do with numbers and data. This is an accelerated course designed to rocket you from beginner to professional, showing you every step along the way, so that you'll walk away ready to begin your programming career. 

Master Matlab's core syntax and coding techniques to create professional-grade programs. Explore essential functions, harness its power for data analysis, modeling, and engineering, and elevate your skills with hands-on exercises and real-world applications that accelerate your learning journey.

Master the foundations of data manipulation in Matlab, including importing data, utilizing for loops, and implementing if statements. Enhance your programming efficiency by modularizing your code, streamlining workflows, and building a solid foundation for advanced Matlab projects.

You'll apply everything you've learned to three real world situations and learn a whole bunch of syntax and details that come up in practice so that you can pull out concrete results from your Matlab programs.  

You'll start by getting your hands dirty exploring Matlab's top-tier visualization and graphing capabilities. After that, you'll learn how to automate graphing and combine the skills you already have to create custom visualizations. And on the way, you'll learn another fundamental aspect of programming: while loops.


To close out, this section will begin by teaching you about recursive programming and how it can help you automate analyses and graphing on a whole new level. After that, you'll dive into the world of matrix multiplication, where you can take advantage of Matlab's state-of-the-art algorithms to open a huge diversity of doors for your programming future. 

Importing and Exporting Data to and from Excel

Task

Awesome!

Importing and Exporting Data to and from Excel

Task