Category: s20-busad360

Lesson 27: Final Project

Zoom Meeting at 11am
https://csupueblo.zoom.us/j/96110896385?pwd=SDRwMkE2c0J6VUhkZ0tJeEY4Y1o4UT09

Meeting ID: 961 1089 6385
Password: 632711

Zoom Meeting at 1pm
https://csupueblo.zoom.us/j/94502460526?pwd=djV2cEdudUhXdDVYSkRQMCtEUWVCUT09

Meeting ID: 945 0246 0526
Password: 548122

Review:

  • DataCamp Assignments and Extra Credit
  • Course Evaluations
  • Final Exam (Project) exemptions

Presentation:

  • Final Project
  • Overview:
    • Extend your stock market simulation by adding 40 more years to simulate retirement fund balances while you are withdrawing money and no longer contributing.
    • The total length of the simulation is 80 years with the first 40 years for growing your retirement fund and the next 40 years for using your retirement fund to provide income.
    • Purpose of the simulation is to estimate how much you will need to contribute annually to reach a comfortable retirement.
  • Assumptions:
    • You have 40 years to build your retirement fund.
    • Your beginning balance is fixed at $10,000.
    • Your annual contribution amount will vary. See below.
    • Your % bond allocation must begin at 20% and increase by 1% each year (every year for 80 years).
    • Beginning in year 41, you must withdraw between $60k and $69k per year to cover living expenses. The last digit of your PID determines your required withdrawal amount. If the last digit of your PID=0, your withdrawal amount must equal $60k; if last digit of PID=1, your withdrawal amount must equal $61k; if last digit of PID=2, your withdrawal amount must equal $62k; and so on.
    • The balance of your retirement fund will continue to be invested, earning returns (or losses) in the stock/bond markets.
  • Calculations
    • Run simulations using varying annual contribution amounts.
    • Calculate the probability of depleting retirement funds 40 years after retirement (i.e., what % of simulated ending balances are less than or equal to zero at year 80).
    • The objective is to identify a contribution level that’s both reasonable/affordable and unlikely to lead to a shortage of funds at the end of 80 years.
  • Deliverable:
    • Write a 2-page paper describing your approach and summarizing your findings.
    • The paper must include a recommended contribution level along with your estimated probability of running out of money.
    • Google Sheets file with simulation also due.
    • Paper and Sheets file are due at the time of our Final Exam.
    • I will provide a file upload link on Wednesday.
More

Lesson 26: Data Visualization in Business

Please read this article while you wait for the meeting to begin!

Join Zoom Meeting at 11:15am
https://csupueblo.zoom.us/j/96110896385?pwd=SDRwMkE2c0J6VUhkZ0tJeEY4Y1o4UT09

Meeting ID: 961 1089 6385
Password: 632711

Join Zoom Meeting at 1:00pm
https://csupueblo.zoom.us/j/94502460526?pwd=djV2cEdudUhXdDVYSkRQMCtEUWVCUT09

Meeting ID: 945 0246 0526
Password: 548122

Review:

  • Recordings posted, use password “Puebl0st@ts”
  • Multiple Regression
  • DataCamp
  • New Course:
    • Real Estate Investment (MBA course)
    • Summer “B” session

Presentation:

  • Data Visualization
    • Patterns
    • Participation
    • 2015 AASA Conference Presentation
Geospatial Visualization in Business

Assignment:

  • Complete DataCamp coursework
More

Lesson 25: Regression Analysis with Index Variables

Join Zoom Meeting @ 11am
https://csupueblo.zoom.us/j/96110896385?pwd=SDRwMkE2c0J6VUhkZ0tJeEY4Y1o4UT09

Meeting ID: 961 1089 6385
Password: 632711

Join Zoom Meeting @ 1p
https://csupueblo.zoom.us/j/94502460526?pwd=djV2cEdudUhXdDVYSkRQMCtEUWVCUT09

Meeting ID: 945 0246 0526
Password: 548122

Review:

Presentation:

  • Creating Index Variables for Regression Analysis
  • Demonstration with Pueblo Real Estate data

Assignment:

  • Work on DataCamp courses

More

Lesson 24: Multiple Regression Revisited

11:15 AM Zoom Meeting
https://csupueblo.zoom.us/j/6114536052?pwd=bmhFYm4wckhlNElvUGQ0OUJZbTloZz09

Meeting ID: 611 453 6052
Password: 399489

1:00 PM Zoom Meeting
https://csupueblo.zoom.us/j/6114536052?pwd=bmhFYm4wckhlNElvUGQ0OUJZbTloZz09

Meeting ID: 611 453 6052
Password: 399489

Review:

  • DataCamp Assignments
  • Recordings

Presentation:

Assignment:

  • Complete DataCamp course work
More

Lesson 23 Recordings – 04/06

Does anyone have video editing skills?

I need to modify the videos before I post and I don’t really have time to teach myself.

I’ve uploaded both recordings to a shared Google Drive folder

Click on the folder for your Section and download the mp4 file.

More

Lesson 23: Pivot Tables in Spreadsheets

Trying something new today. Zoom has better video recording capability.

Join Zoom Meeting

https://csupueblo.zoom.us/j/157402034

Meeting ID: 157 402 034

Review:

  • Covid-19 Data Analysis and Forecasting
  • Stock Market Simulation Project
  • Grades
  • Cool Question Contest
  • Schedule = DataCamp trilogy + final

DataCamp Options:

Presentation:

  • Track Covid-19 Cases in Colorado by County

Assignment:

  • Work on DataCamp Assignments
  • Email me if you plan to work on Python (instead of Sheets)
  • Email me if you plan to do extra credit (optional Data Science Track)
More

Lesson 22: Predicting COVID-19 Mortality Rates

Review:

Presentation:

  • Build a Model to Forecast COVID-19 Mortality Rates in the US
  • I will walk through the process step by step
  • Get your own worksheet ready so you can follow along

Assignment:

  • Have a good weekend
More