A two part assignment including microsoft word and excel.

User Generated

Punaqyre45

Business Finance

Description

In this stage you will do statistical reasoning and mathematical modeling to show central tendency and two variable analyses, including regression with equation and R squared value from the data set you chose in Week 2. The purpose of this assignment is to have you practice creating visuals using your own data. This shows you how you will be working with data in your own careers.

The purpose of this assignment is to gain experience creating visuals using the data for the topic you selected in Week 2. Use statistical reasoning and mathematical modeling to show central tendency and two-variable analyses, including regression with equation and R2 value.

Create at least three visuals. (This portion is created in Microsoft Excel)

  • One visual must be a scatter plot with trend line, equation, R2 value, and prediction value.
  • Two of the remaining required visuals can be of the following format: histogram, box and whisker plot, or pie chart.
  • Please note that the data set that you chose in Week 2 includes data that will not be needed to create your visuals. Quantitative reasoning requires critical thinking to decide what data is necessary.

Create a Microsoft® Word document that includes your three visuals and the following items:

  • Title of your project and the scenario you are addressing
  • Brief description of each visual (15 to 50 words)
  • Consider including the following for each visual when applicable:
    • A chart title that is appropriate for the data
    • A descriptive x-axis label
    • A descriptive y-axis label
  • For your xy scatter plot, make at least one prediction using the trend line equation for a date in the future. How confident are you in this prediction? State your prediction and provide justification (50 to 150 words).
  • If you created a box and whisker plot, describe the central tendency of the values. What does this tell you about the data and about your project?
  • Calculate the mean of the sample data.

Unformatted Attachment Preview

1 1 X Matt Rusterud INSERT FILE HOME PAGE LAYOUT FORMULAS VIEW DATA REVIEW PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing H12 : X & fic N 0 M L A K C B D I F E F G H 1 2 3 Humanities and Sciences Scenario Predicted College Tuition and Fees 4 Topic 3 5 Scenario 3 Review college data of the yearly tuition and fees. Predict the cost of yearly tuition and fees in 2018. 6 7 8 g 10 12 *13 Yearly Yearly Books & Living Year Tuition Tuition Supplies Costs and Fees 2015 $29,450 $1,250 $12,400 $44,190 2014 $24,444 $1,038 $10,292 $36,679 2013 $20,288 $861 $8,542 $30,442 2012 $17,245 $732 $7,261 $25,876 2011 $16,412 $625 $6,532 $24,112 2010 $15,984 $600 $5,899 $22,984 2009 $8,618 $1,200 $15,682 $25,770 2008 $7,153 $996 $13,016 $21,389 2007 $5,937 $827 $10,803 $17,753 2006 $14,658 $703 $9,183 $24,702 2005 $13,549 $699 $5,771 $20,142 2004 $12,435 $612 $5,256 $18,415 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 to 36 37 Topic 2 - Criminal Justice .. Topic 4 - Social Sciences Topic 3 - Hum. & Sciences Topic 5 - Business Topic 6 - Education READY 回
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi, Find attached the completed paper for your review.Let me know if you need anything edited or changed.Looking forward to working with you again in the futureThank you.
Attached.

Humanities and Sciences Scenario
Topic 3
Scenario 3

Predicted College Tuition and Fees

Review college data of the yearly tuition and fees. Predict the cost of yearly tuition and fe
Books & Supplies
$
1,250
$
1,038
$
861
$
732
$
625
$
600
$
1,200
$
996
$
827
$
703
$
699
$
612

Living Costs
$
12,400
$
10,292
$
8,524
$
7,261
$
6,532
$
5,899
$
15,682
$
13,016
$
10,803
$
9,183
$
5,771
$
5,256

50000
45000
40000

Yearly tuition and fees

Year
Yearly Tuition and Fees Yearly Tuition
2015
44190 $
29,450
2014
36679 $
24,444
2013
30442 $
20,288
2012
25876 $
17,245
2011
24112 $
16,412
2010
22984 $
15,984
2009
25770 $
8,618
2008
21389 $
7,153
2007
17753 $
5,937
2006
24702 $
14,658
2005
20142...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags