Reference no: EM13491547
ActiveData Graded Homework Assignment
The attached Excel workbook contains data that has been extracted from NetSuite (via the Export to CVS file function at the bottom right of all reports). Use the data and the workbook to complete the following homework questions. Perform all analyses in this Excel workbook and answer the narrative questions on the same page as the analysis (use Insert Text Box) so that you only submit ONE file to your Assignment Folder according to the date in the Syllabus. Remember to rename the workbook under your name so that it can be easily identified for grading.
Part 1 - Purchase Order Summary/Pivot Analysis
Go to the Tab named PO Register. "Clean" the data according to the following instructions. Note: The concept of how data should be presented inorder for Active Data commands to work, applies all the time. This process of "cleaning" or preparing data for analysis is common in many data analysis packages.
a. Most of ActiveData's commands require that the column names be in row 1 and that row 2 and beyond contain the data. In addition to this, ActiveData (and often Excel) looks at the first couple of rows of each column to determine what type of data the column contains (text, numbers or dates).
Your csv file has 5 rows before the column names and an extra row after the column names with a title in it and then the raw data rows.
Remove the first 5 rows and row 7:
Remove Grand Total rows
a. As the CFO, you would like to see this report summarized by vendor, with amount totals, displayed in a pivot table that shows Status across the top, with Vendors down the left side, with amounts and grand totals. (Check your pivot totals to your data totals as a last step.)
b. Question: As CFO, verbally describe in a narrative whether there are any things Ramsey PO Clerks should be looking out for or doing better in their data entry.
c. Question: As CFO, verbally describe the results, and do you have any concerns in the summary that you see?
|
What each of these strata charts show
: As CFO, verbally describe in a narrative what each of these strata charts show and how they can be used in financial management decision making.
|
|
What is vendor duplicate payment analysis
: As CFO, verbally describe in a narrative whether there are any things Ramsey PO Clerks should be looking out for or doing better in their data entry.
|
|
Explain a radical chlorination reaction
: Assume that you have carried out a radical chlorination reaction on (R)-2- chloropentane and have isolated (in low yield) 2,4-dichloropentane.
|
|
Define what is the band gap energy in kilojoules per mole
: What is the band gap energy in kilojoules per mole if bule diamonds absorb orange light with a wavelength of 675nm
|
|
Determine what type of data the column contains
: As the CFO, you would like to see this report summarized by vendor, with amount totals, displayed in a pivot table that shows Status across the top, with Vendors down the left side, with amounts and grand totals. (Check your pivot totals to yo..
|
|
Determine the temperature inside the box
: The rms speed of 1.0 mol of argon atoms (atomic weight 40 g/mol) in a box is 680 m/s. Treat the gas as ideal. What is the temperature inside the box
|
|
Explain the unit of quadrillion british thermal units
: World energy supplies are often measured in the unit of quadrillion British thermal units (10^12 Btu ), generally called a "quad." In 2015, world energy consumption is projected to be 5.81 x 10^17Kj
|
|
State what is the equilibrium concentration of fluorine
: What is the equilibrium concentration of fluorine if the initial concentrations of bromine and fluorine were 0.113 moles/liter in a sealed container and no product was present initially
|
|
By what percentage should you reduce the tension
: In order to decrease the fundamental frequency of a guitar string by 4.0%, by what percentage should you reduce the tension
|