Warning: Trying to access array offset on value of type bool in /home/topgsnkq/timelyhomework.com/wp-content/themes/enfold/framework/php/function-set-avia-frontend.php on line 570
The totals of the number of laser printers sold in the years 2008 through 2013 by Smart Brothers Computer Store, assignment help
This assignment is to be done using Excel. You must use Excel for the calculations (either using a formula which references other cells or an Excel function if appropriate). Do not just type the answer into Excel.
See the attached Excel file for an example of what is meant by “using Excel”.
Problem 1: Charts
The totals of the number of laser printers sold in the years 2008 through 2013 by Smart Brothers Computer Store are as follows:
|
2008 |
2009 |
2010 |
2011 |
2012 |
2013 |
|
983 |
1,052 |
1,117 |
615 |
250 |
400 |
Draw a line graph representing the data. Use an interval of 250. Be sure to include a title and label your axes.
Problem 2: Percents
The financial officer allows $3,400 for supplies in the annual budget. After three months, $898.32 has been spent on supplies. Is this figure within 25% of the annual budget?
Problem 3: Trade Discounts
A trade discount series of 10/5 was given on ladies’ scarves listed at $18. Find the net price of each scarf.
Problem 4: Statistics
Find the mean, median, mode, variation, and standard deviation for the following gas prices ($/gallon). You may use Excel functions.
|
2.19 |
2.35 |
2.11 |
2.54 |
2.48 |
2.36 |
2.19 |
|
2.40 |
2.64 |
2.47 |
2.33 |
2.61 |
2.42 |
2.37 |
|
Problem |
Points |
|
1 |
.75 |
|
2 |
.75 |
|
3 |
.75 |
|
4 |
.75 |
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"
