Application Exercises Note: The existing data files referenced in these exercise

Question

Application Exercises Note: The existing data files referenced in these exercises are available on the book's Web site: www.pearsonhighered.com/valacich Spreadsheet Application Analyzing Server Traffic 4-34. Campus Travel has recently found that its Internet connections between offices are becoming slow, especially during certain periods of the day. Since all the online traffic is maintained by another company, an increase in bandwidth requires a formal approval from the general manager. The IS man- ager has proposed to increase the bandwidth of the company's network; in a few days, he has to pres- ent the business case for this proposal at the weekly meeting of the department heads. You are asked to prepare graphs for the presentation to support the IS manager's business case. In the file ServerLogs.csv, you will find information about the network traffic for a one-week period. Prepare the following graphs: Total bandwidth used for each day (line graph) Bandwidth used per day, by time period (line graph) Average bandwidth used in each two-hour period (line graph) Format the graphs in a professional manner and print out each graph on a separate page. (Hint: If you are using Microsoft Excel's Chart Wizard, select "Place chart: As New Sheet.")

Explanation / Answer

I have produced the required charts, you may format them to your liking, if you want steps or how to do it, drop a comment and i'll explain to you.

I have made changes in the workbook too, like adding the sums and averages.

Here is the link: https://drive.google.com/file/d/1NCOjkcntbL7uJqmXO97zl2r7mxzS8aiD/view?usp=sharing

You can see the way I did it, by right-clicking the graph and selecting "change data" and then click edit and you will be able to see.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.