Weekly Reading Quiz #5

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

MIS0855: Data Science

Email *

Last name *

Gandel cites the case of Reinhart and Rogoff, where an Excel spreadsheet error: *

revealed an important insight regarding European manufacturing

led them to accidentally exclude five countries from their analysis

combined two data sets that weren't supposed to be combined

used the wrong multiplication factor in a calculation

Gandel cites the case of Barclays effort to purchase Lehman Brothers, where the following Excel error resulted in the accidential purchase of 179 toxic assets: *

rows were pasted into the wrong spreadsheet

cells were hidden instead of deleted

a formula computed the wrong threshold for approving an asset

the spreadsheet wasn't password protected

According to Redman, which is NOT a cause of bad data? *

Everyone is invested in getting the data right

Users of data create "work arounds" instead of addressing root causes

People creating the data don't understand how others will use it

Creators and users of data have poor communication

According to Taber, what is a common way Excel corrupts imported data? *

Dates are often converted into integers (a single number)

Numbers less than -1,000,000 are rejected

Data is randomly deleted without notification

Excel rejects data that contains letters instead of numbers

According to the Microsoft article, before cleaning your data you should: *

Talk to the last person to work with the data

View it in Microsoft Word to make sure it is formatted properly

Make sure everything is spelled correctly

Make a backup copy of the data in a separate workbook

Enter your first and last name in the box below. *

By doing this, you pledge that no one has helped you with this quiz and your responses are your own work.

A copy of your responses will be emailed to the address you provided.

Submit

Clear form

Never submit passwords through Google Forms.

reCAPTCHA

Privacy Terms

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms