# Project #32032 - computer science

THE HW is due by 11:30 on the 30/5/2014 (EST)

http://cs101.wvu.edu/media/21224/hiv-aids-statistics-problem.pdf >>> HW instructions

http://cs101.wvu.edu/media/21242/data_files.zip >> HW data

this website: http://cs101.wvu.edu/resources/homework/

It has videos and help for the homework!

Here are some quick tips on homework 2:

Step 5h - This can be easy or a bear.  The one tip I would strong suggest is that if you have trouble, do look at manage rules.  The thing I dislike about conditional formatting is that if something doesn't work, people will often layer in another rule (that is in conflict with the first and cancel it out).  If things are not working, go to Manage Rules under the conditional formatting command and kill off all formatting rules and start from scratch.

Step 9 will drive you slightly batty.  In step 9, you are on the Infection Rates sheet.  You're writing a formula that will reference data on another sheet. So, for column c, start to write the deaths/living with hiv formula by doing this.  Say you are calculating Canada's death rate - type = in the cell then click on the HIV Statistics tab at the bottom left of the page, then go to click on deaths in the Canada row for the year you are working on, then click / then click on the living with hiv cell for the year in question for Canada.  In practice, this will make quite a bit of sense.  If you watch the homework help live video, that should help as well.  Let me know if you have questions.

For the analysis questions, use wikipedia if you need some help.  I'll address some thoughts below.  If you need help with the graphs, I'll send an expanded email tomorrow.  In the meantime, if you have questions, do let me know.

Question A is a great question to answer.  Simply tell me what trendline you used (the supplemental material has some great information that may be of assistance in choosing your trendline) and why - often describing the trendline and the values are sufficient here.

Question B - Do a little wikipedia research. Hint here - a citation to research always makes me happy.

Question C - Are all cases reported?

Question D - I'll leave this to you - give it some thought.  There are different directions I've seen students take this.

Question E - Look at the data and tell me what you think. Cite the data, please in your answer.

The Supplemental content :

http://cs101.wvu.edu/resources/supplemental-content/

It has information on the trendlines.  You may find it helpful.

For Step 11, here are my thoughts.

First, the easiest thing to do with the graph is to manage the data.  If the graph does not look the way you want it to, go to the ribbon, hoose to select data.  The box on the left will be the y axis. The box on the left will be the x axis.  There can be multiple items on the y axis, but only one on the x axis.  I will often deliberately insert a blank chart, then use select data to add line by line to the y axis (just select the series of data you want to graph - it is all spelled out in the homework) and then I will switch over and do the x axis.

Second, be sure to select the kind of graph we specify.  If you go to insert the graph and hover over the options, you'll see each named.  So for 11a, choose the 2-D line chart.  If you don't and you choose something different, it may not allow you to insert the trendline.

Third, to insert the trendline, click (left click) on the line to select it. Then right click to add the trendline.  Read through the supplemental content, but I can boil it down to this.  Choose the trendline that brings the r-squared value closest to 1 and looks realistic.  For example, if you are tracking gas prices and the trendline you choose looks great but does a nosedive to negative numbers - probably not the one you want.  A steady increase that reflect the data is likely appropriate there.

Fourth, don't forget to project forward the number of periods we ask you to - just inserting the trendline isn't going to work.

 Subject Computer Due By (Pacific Time) 05/30/2014 05:00 pm
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews