Blog

We refer to the following LP as (P’), or the primal.     Find a feasible solution to (P’) where , , .

In protest of the practices of fellow priest Johann Tetzel, Martin Luther did not nail, but mailed his 95 Theses to his Bishop, which essentially defended what teachings?

Tableau Prep (.tflx) If you use Tableau Prep to clean the data file, please upload your work file, i.e., Packaged Tableau Flow (.tflx) ) to this question. 

Excel (.xlsx) If you use Excel to clean the data file, please upload your work file (.xlsx) used when cleaning the data file to this question.

The file below contains 5-year check out history data of Children’s Book/Disc at a local library.   Data file: Check Out History for 5 Years by Holdings Code.xlsx Please prepare the data file for further analysis using Microsoft Excel, Tableau Prep, or BOTH (hint: Use Excel for #1 below and Tableau Prep for the rest) At the minimum, the clean data file should have the following characteristics: The final data file should… include column headings on the first row not include totals and report footer not include merged cells (Row 127-128 must be corrected) Title column – use all uppercase letters for the title data Publication Year (008/07-10) column – should be renamed to Publication Year Author column Separate author’s first name and last name on two different columns called Author First and Author Last Separate the DLC number into a new column called DLC.  Try your best to keep only the numbers. For example,  Author DLC Pearson, Ridley, author. (DLC)n 84199915 84199915 Include only the following columns in the final, clean data file in this order: Item Barcode Title  Author Last Author First DLC Status Publication Year Last Circulation Date 2019 2018 2017 2016 2015 Prepare the final data file in a CSV format and upload to this question.  Note: this is an actual data file and is quite messy.  Please try your best.  Upload the cleaned data file in a CSV file format to this question.  You will explain the process utilized when cleaning this data file in the next question.

Explain how you cleaned the data file in the space below. Use numbered steps so I can follow along your process. (5 points) Upload the file(s) you used when cleaning the data to the questions below. (5 points)

Based on the spreadsheet below, what would be the best way to split data in Column A into First Name and Last Name using Microsoft Excel?

A researcher designs an experiment to test whether the type of reward offered (cash back, travel miles, or gift cards) and the delivery method (email or direct mail) affect the amount customers spend in the following month. Customers are randomly assigned to one of the six possible combinations. What is the response variable?

Download the CD portion of the quiz and answer the questions within. Then upload your completed CD below. Exam 4 CD Portion.docx

An interaction plot shows two lines that cross each other. What does this tell you?