Name: Solution
Instructor:
Financial Accounting, Sixth Edition by Kimmel, Weygandt, and Kieso
Primer on Using Excel in Accounting by Rex A Schildhouse
Date:
Course:
P83A, Journalize transactions related to bad debts.
Presented below is an aging schedule
EXERCISE 8. TIME SERIES ANALYSIS AND INDEX NUMBERS
1. An item with a price relative of 132 cost $10.75 in 2006. Its base year was 1992.
a. What was the percentage increase or decrease in cost of the item over the 14year period?
b. What did the item cost
10, 20, 12, 17, and 16
10
20
12
17
16
mean
median
mode
15
16
#VALUE! no repeated values!
10, 20, 21, 17, 16, and 2
10
20
21
17
16
2
mean
median
mode
14.3333333
16.5
#VALUE! again no repeated values!
Why are the results so different to the ones obtained in
A small town in the middle of the country has only 10 citizens. The citizens and their
earned incomes in the year 2007
and in the year 2013
are listed below
Data is ordered by income
Income
2007
2013
Zak
Erika
Bill
Juan
Harry
Jose
Emily
Kai
Robert
Kathlee
1. A partial relative frequency distribution is given.
Class
A
B
C
D
Relative Frequency
.22
.18
.40
a.What is the relative frequency of class D?
As the total relative frequency has to sum up to 100%, then the relative frequency for class D is
= 1  ,22 
EXERCISE 2. TABULATION AND GRAPHICAL REPRESENTATION
February 2015
1. A partial relative frequency distribution is given.
Class Relative Frequency
A
.22
B
.18
C
.40
D
a.
b.
c.
d.
What is the relative frequency of class D?
The total sample size is 200. What
EXERCISE 4. MEASURES OF DISPERSION AND SHAPE
1. Using data from question 3 of Exercise 3 related to annual starting salaries for college
graduates for marketing majors and accounting majors follow (data are in thousands
US$):
Marketing Majors:
Accounting
Five observations taken for two variables follow.
X: 4
Y: 50
6
50
11
40
3
60
16
30
a.Draw a scatter diagram with x on the horizontal axis.
b.What does the scatter diagram developed in part (a) indicate about the relationship between t
c. Compute and inter
EXERCISE 7. ASSOCIATION BETWEEN VARIABLES
1. Five observations taken for two variables follow.
X:
Y:
4
50
6
50
11
40
3
60
16
30
a. Draw a scatter diagram with x on the horizontal axis.
b. What does the scatter diagram developed in part (a) indicate about
6. Consider the following time series.
t
1
2
3
4
5
Yt
6
11
9
14
15
Develop an equation for the linear trend component of this time series. What is the forecast for t=6?
Mean
t
Yt
VAR
3
11
a
b
Forecast T=6
Covar
2
10.8
4.7
2.1
17.3
4.2
7. The enrollment da
Educational level
The following crosstabulation shows household income by educational level of the head of household (Statistical Abstract o
Household Income ($ 1000s)
Not H.S. Graduate
H.S. Graduate
Some college
Bachelor's degree
Beyond Bachelor's degree
a) Build the contingency table for Inequality nad Development.
Inequality
Development
TOTAL
High
5
5
10
Medium
9
9
18
Low
5
5
10
TOTAL
19
19
38
b) Show the frequency distributions for Inequality and Development
Inequality
High
Medium
Low
TOTAL
ni
5
9
5
19
Name: Solution
Date:
Instructor:
Course:
Financial Accounting, Sixth Edition by Kimmel, Weygandt, and Kieso
Primer on Using Excel in Accounting by Rex A Schildhouse
P84A, Compute bad debt amounts.
Here is information related to Shashko Company for 2012.
Name: Solution
Date:
Instructor:
Course:
Financial Accounting, Sixth Edition by Kimmel, Weygandt, and Kieso
Primer on Using Excel in Accounting by Rex A Schildhouse
P108B, Prepare journal entries to record issuance of bonds, interest, and straightline a
Introduction to Financial Statements
Early records of accounting in Mesopotamia, Egypt, India, Greece, Rome
Prenumerical counting systems predated written language.
Emporion = market
Bookkeeping vs. Accounting
Accounting = information system that identif
Two of the major characteristics that make accounting information useful are
Select one:
a. Understandability and consistency.
b. Relevance and Faithful representation.
c. Verifiability and timeliness.
d. Comparability and flexibility.
Kingery Corporation
EXERCISE 3. MEAN, MEDIAN, MODE + MEASURES OF LOCATION
1. Consider a sample with data values of 10, 20, 12, 17, and 16. Compute the mean, the
median and the mode.
2. Consider a sample with data values of 10, 20, 21, 17, 16, and 2. Compute the mean.
Why are
EXERCISE 6. BIVARIATE DATA ANALYSIS
1. The following crosstabulation shows household income by educational level of the
head of household (Statistical Abstract of the United States: 2002).
Educational level
Under 25
Not H.S. Graduate
9285
H.S. Graduate
10
Using data from question 3 of Exercise 3 related to annual starting salaries for college graduates for marketing majors and a
Marketing Accounting
34.2
33.5
45
57.1
39.5
49.7
28.4
40.2
37.7
44.2
35.8
45.2
30.6
47.8
35.2
38
34.2
41.1
42.4
41.7
53.9
40.8
55
DATA ANALYSIS

REEVALUATION EXAM

July 14th 2016
NAME: . SURNAME: .
Instructions: fill in your name and surname in every sheet. Report the answers below the
question. Every annotation in the back side of every sheet will be neither revised nor marked.
1
EXERCISE 5. MEASURES OF INEQUALITY
1. A small town in the middle of the country has only 10 citizens. The citizens and their
earned incomes in the year 2007 and in the year 2013 are listed below:
Income (US $)
Zak
Erika
Bill
Juan
Harry
Jose
Emily
Kai
Robe
1. An item with a price relative of 132 cost $10.75 in 2006. Its base year was 1992.
a. What was the percentage increase or decrease in cost of the item over the 14year period?
b. What did the item cost in 1992?
Index 2006 based 1992 =
a. Increase
132
In