Visualizing Data

Analyzing and Visualizing Data
When thinking about data visualization, it is important to understand regular expressions in data analytics. Therefore, note the importance of data visualizations and choose two types of expressions
(* – wildcards for example) and discuss the difference between the two types of expressions.
In an APA7 formatted essay for above.

Data Visualization

You serve as the Deputy Chief Financial Officer of your city government. Recent

discussions in upper-level management meetings highlight concerns about the

government’s financial performance. Juliet Sweeting, the city’s Chief Financial

Officer (CFO) asked you to help benchmark your city’s financial performance against

another city of similar size. You have been tasked to create a Dashboard in Excel

that can use to compare your city to any other city. The comparison will be done with

ratios commonly used to evaluate the financial health of city governments.

Your goal is to choose another city similar to yours and compute the ratios for each

city. Create a dashboard whereby Ms. Sweeting, CFO can easily read and

understand the results in 30 seconds or less.

  1. Find the Comprehensive Annual Financial Reports for two cities.
  2. Type in the financial statements of the two cities in side-by-side fashion on Tab 3

of your Excel file (Do not copy and paste a picture. You need these numbers for

your computations). If data not shown on the financial statements is necessary

for your ratio computations, create an “Other Information” area to post this data

for the two cities.

  1. Use Tab 2 of your Excel file to show the computation of the ratios by category; see the Appendix below. The information used to compute the ratios should flow

from the data in Tab 3. Make sure it is clear to your CFO that you know how to

compute and interpret these ratios.

  1. Use Tab 1 to create a dashboard showing the results of the ratios, comparing

the two cities. The dashboard should be composed ONLY of clearly-marked

graphs that convey the data in a way that makes it easy to read and understand

quickly.

  1. When Ms. Juliet Sweeting, CFO changes numbers on the financial statements

on Tab 3, the dashboard graphs should automatically change.

Using frequency recording, the data

  1. When using frequency recording, the data label on the y-axis will be (select all that apply):
    A. Number of behaviors
    B. Percent
    C. Latency
    D. Time

Percent occurrenceLinks to an external site.

  1. “Percentage” measures are (Select all that apply):
    A. A ratio of different dimensional quantities
    B. A proportion of correct to incorrect
    C. A proportion of intervals in which the target behavior occurred
    D. Acceptable to use if the behavior occurs 1-2 times a day
    Step 3 Now, let’s practice. Let’s look at the measurement of the dependent variables section from five single subject research design studies and identify the measurement systems:
    HERE IS AN EXAMPLE: ANALYZING THE MULTIPLE FUNCTIONS OF STEREOTYPICAL BEHAVIOR FOR STUDENTS WITH AUTISM: IMPLICATIONS FOR ASSESSMENT AND TREATMENTLinks to an external site.
    Select the measurement system* used from the following:
    (*Describe the single measurement system used across Brad, James, Julie, Rita, and Tom only)
    _ Frequency • Interval o X Partial interval o Whole interval
    o Momentary time sample
    • Percent correct opportunities (e.g. correct, accuracy, etc.)
    Study 1: THE EFFECTS OF ESTABLISHING OPERATIONS ON PREFERENCE ASSESSMENT OUTCOMESLinks to an external site.Open this document with ReadSpeaker docReader
    • Frequency
    • Interval
    o Partial interval
    o Whole interval
    o Momentary time sample
    • __
    Percent opportunities (e.g. correct, accuracy, etc.)

Market Research Data

Templates to complete the assignment (PowerPoint OR Word Document template is required)

Competencies
In this project, you will demonstrate your mastery of the following competencies:

Describe how managerial accounting supports management information systems
Utilize managerial accounting techniques and models to support an organization’s strategic plan
Explain how managerial accounting is used to make decisions about short-term business opportunities, capital investments, and evaluating operational performance
Scenario
Your business has been open for a month, and you have prepared an income statement and completed a variance analysis on the data. Now you will meet with investors and a few other internal stakeholders to share your company’s progress over the past month and how it has performed with respect to your cost and budget projections. The investors would like to see the thought process behind your financial strategy and how your company has performed in its first month. They have therefore asked you to present a report that includes the costing and income data from your Project Workbook.

Directions
Submit a detailed report to your potential investors and other stakeholders to explain and defend your costing strategies and to share your business’s performance to date. Your report can be in the form of a PowerPoint presentation or a Word document (based on the templates provided in the What to Submit section). In either format, be sure to effectively communicate with your stakeholders by breaking down concepts and using investor-friendly language to build their trust and confidence. If you choose to do a PowerPoint presentation, you’ll need to include speaker notes for each slide.

Introduction: Provide a short overview of your company and the purpose of this report.
Business Overview: Name your company and describe its business and your vision for its future.
Purpose of the Report: Explain the purpose of the report and describe why the information is important.
Methods and Approach: Explain the management accounting methods you used for generating the information that you are about to share in terms of your adherence to industry standards and the American Institute of Certified Public Accountants (AICPA) code of ethics.
Financial Strategy: Review your original business plan and costing strategies.
Costing System: Justify the use of job order costing for this business. Be sure to compare and contrast the various costing systems you learned about in this course as part of your defense.
Selling Prices: Share and explain the selling prices you established for each of your products. Be sure to reference your cost-volume-profit analysis in your defense.
Contribution Margin: Share and explain your contribution margin per unit. Be sure to reference your cost-volume-profit analysis in your defense.
Target Profits: Identify your break-even points for achieving different target profits. Then explain the target profits you selected for each area of your business. Be sure to reference your cost-volume-profit analysis in your defense.
Financial Statements: Using the information in the Milestone Two Market Research Data Appendix, assess your financial performance to date. (Attached)
Statement of Cost of Goods Sold: Share the statement of cost of goods sold and logically interpret the business’s performance against the provided benchmarks.
Income Statement: Share the income statement and logically interpret the business’s performance against the provided benchmarks.

Psychological testing data

Quiz: Statistical Concepts

1) IQ scores tend to be fairly stable over time. This is because IQ tests have high:
a) Validity
b) Reliability
c) Measurement error
d) Cultural fairness

2) IQ scores correlate highly with academic performance. This is an example of IQ test:
a) Validity
b) Reliability
c) Discrimination
d) Parallelism

3) Knowing a test’s standard error of measurement tells us:
a) The likelihood of scoring errors
b) How test taker distractibility distorts responses
c) The likelihood that test takers will answer questions incorrectly
d) How many points test scores are likely to vary over time

4) Dr. Hathaway writes the following statement in a test report: “Jennifer’s Verbal Comprehension Index of 102 is slightly higher than her Perceptual Organization Index of 99. This difference reflects slightly stronger verbal than non-verbal skills.” This statement:
a) Accurately describes a significant VCI/POI difference
b) Is inaccurate because the score difference is non-significant
c) Is accurate because the non-significant VCI/POI difference is described as “slight.”
d) Is inaccurate because the VCI is above average, the POI is below average, and thus the difference is not “slight.”

5) Jose’s WRAT-IV Spelling score is significantly higher than his Word Reading score, at a 5% level of significance. This means that:
a) Only 5% of the population has a difference between these scores at least as large as Jose’s
b) There is a 95% chance that Jose’s Spelling score will still be higher than Word Reading if Jose is retested
c) There is a 5% chance that the Spelling/Word Reading difference is due to test error
d) Both b and c

6) Convert a WAIS-IV IQ (Mean = 100, s = 15) of 95 to a z-score:
a) -0.05
b) -0.33
c) -0.95
d) 6.33

7) A z-score of 0.5 is at what percentile?
a) 25th
b) 50th
c) 69th
d) 84th

8) Abdul obtains a score of 13 on the WAIS-IV Block Design test. If this is the only information that you have, your best estimate of his IQ would be:
a) 87
b) 113
c) 115
d) 130

9) Someone who obtains a T-score of 60 on the MMPI-II Depression scale is scoring higher than what percent of the population?
a) 60%
b) 70%
c) 80%
d) 84%

10) Factor analysis is:
a) A statistical method that shows how variables cluster, based on the correlations between them
b) A modern form of psychoanalysis
c) A way to determine if group means are significantly different
d) A way to draw causal inferences from correlations between variables

Economic Data

In preparation for writing each of your Discussions, you should submit your Annotated Bibliography Assignment on the topic that is being covered for the week (Marketing, Accounting, Finance, Management, Economic Data Analysis, International Business).

Provide an APA formatted Citation (this should look like what you would include in a normal reference section.
Summarize the source and discuss the research study that was conducted and what the findings were.
Assess the source and discuss how useful it is and how it compares with other sources in your paper.
Reflect on how the source will be useful to you in your discussion. How does it help to shape your argument and how are you using it to shape your writing?

Economic Data

In preparation for writing each of your Discussions, you should submit your Annotated Bibliography Assignment on the topic that is being covered for the week (Marketing, Accounting, Finance, Management, Economic Data Analysis, International Business).

Provide an APA formatted Citation (this should look like what you would include in a normal reference section.
Summarize the source and discuss the research study that was conducted and what the findings were.
Assess the source and discuss how useful it is and how it compares with other sources in your paper.
Reflect on how the source will be useful to you in your discussion. How does it help to shape your argument and how are you using it to shape your writing?

SEARCHING DATABASES

When you decide to purchase a new car, you first decide what is important to you. If mileage and dependability are the important factors, you will search for data focused more on these factors and less on color options and sound systems.

The same holds true when searching for research evidence to guide your clinical inquiry and professional decisions. Developing a formula for an answerable, researchable question that addresses your need will make the search process much more effective. One such formula is the PICO(T) format.

transform a clinical inquiry into a searchable question in PICO(T) format, so you can search the electronic databases more effectively and efficiently. You will share this PICO(T) question and examine strategies you might use to increase the rigor and effectiveness of a database search on your PICO(T) question.

Review the Resources and identify a clinical issue of interest that can form the basis of a clinical inquiry.
Review the materials offering guidance on using databases, performing keyword searches, and developing PICO(T) questions provided in the Resources.
Based on the clinical issue of interest and using keywords related to the clinical issue of interest, search at least two different databases in the Walden Library to identify at least four relevant peer-reviewed articles related to your clinical issue of interest. You should not be using systematic reviews for this assignment, select original research articles.
Review the Resources for guidance and develop a PICO(T) question of interest to you for further study. It is suggested that an Intervention-type PICOT question be developed as these seem to work best for this course.
Post a brief description of your clinical issue of interest. This clinical issue will remain the same for the entire course and will be the basis for the development of your PICOT question. Describe your search results in terms of the number of articles returned on original research and how this changed as you added search terms using your Boolean operators. Finally, explain strategies you might make to increase the rigor and effectiveness of a database search on your PICO(T) question. Be specific and provide examples.