EARLY ON YOUR MAC. MAC USERS MAY NOT BE ABLE TO USE THIS COMMAND. USE A LAB COMPUTER, INSTEAD.
Before you start writing your program: Read all of these instructions carefully. Submitting a development plan is not required for this assignment. I suggest that you create one and use it when writing your program. TRY USING xlsread() and xlswrite() EARLY ON YOUR MAC. MAC USERS MAY NOT BE ABLE TO USE THIS COMMAND. USE A LAB COMPUTER, INSTEAD. Problem: Program: Lab10.m The number of touchdowns, extra points, and field goals made by Auburn are on the from the teamStat spreadsheet in auburnStats2014.xls. Compute the points made, and write a summary on the pointSummary spreadsheet in auburnStats2014.xls. Create a stacked bar chart and pie chart to compare the category points. Instructions: See Standards for Documentation of MATLAB Programs on the Resources page on Canvas Insert comments at the top and throughout each file • Include the follow comments at the beginning of this (and ALL) files. % submitter’s name, GROUP # Grade of ZERO for files with submitter name not part of Canvas group % other group members’ names For your own protection, type “none” if submitting alone. % assignment number Zero points for comments if no collaboration statement % date you completed the assignment % statement(s) about collaboration % a short narrative about what the file does • Use the algorithm given below as comments throughout your program. Use clc and clear all at the beginning of your program. Use descriptive variable names. Use Sample Input/Output as a guide. No extra output, i.e., use semicolons! Use Smart Indent to ensure correct indenting. Using the data file • Protect your program from crashing by making sure that the file exists. If the file doesn’t exist, print an error message and end the program. CONSTANT variables • Save the names of the file AND the spreadsheets in CONSTANT variable names; use the variable names as the argument with the xlsread() and xlswrite(). Input • Read the Auburn 2014 season game scoring statistics from the teamStat in auburnStats2014.xls and into a numeric and a text matrix. Note the difference and relationship of the number of rows in the two matrixes. • Your program should work for any number of games in the file. Use size obtain the number of games (rows) and columns. YOU DO NOT KNOW THE NUMBER OF GAMES, SO ALL REFERENCES TO ROWS DEPEND ON THE SIZE. New commands xlswrite() subplot() sprint(),text() axis() pie() “stacked” bar() title(),legend() xlabel(),ylabel() cell array {}
