Need help converting this array to a matrix

2015 11 30
0 个回答
更新时间：2021 8 20
2 次查看（30 天）

0 个投票

A = importdata('sales.txt')
A =
1 1202 1533 1488 2144 1677
2 1005 1268 1356 2200 1556
3 1345 1650 1533 2535 1599
4 1565 1853 1645 2750 1625
5 1456 1675 1480 2695 1582
6 1245 1375 1510 2455 1575
7 1305 1638 1590 1103 1309
8 2547 2124 2345 3411 2111
9 1567 2008 1754 2875 1900
10 1600 2375 1666 3550 1400
11 2100 1590 1890 3100 1800
12 2245 3375 4510 4455 3575
and after i do that i need to
Calculate the following:
  • Total sales for each employee
  • Total sales for each month
  • Average sales for each month
  • Which employees receive a bonus each month (Create a function to do this.)
  • The total sales overall
also....
  • Read the text file as given
  • Preform above calculations using loops
  • Have a user-defined function
  • Write ALL of the input data to an Excel spreadsheet
  • Write ALL of the results to an Excel spreadsheet
  • Include no more than four Excel write statements
I am stuck at the beginning with the matrix so i cant get started on the rest of this project. and how do i refer to a line in the matrix so i can calculate that average and all that other stuff? any help at all would be great, thanks

回答（0 个）

此问题已关闭。

标签

关闭：

MATLAB Answer Bot
MATLAB Answer Bot
2021-8-20

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by