Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 24, Problem 3R
To determine
Calculate the variance with formulas.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Correctly solve this .
Do it correctly with step by step explanation.
Please include excel formula
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.
Input area:
Year
X
Y
1
13%
27%
2
26%
36%
3
7%
11%
4
-5%
-29%
5
11%
16%
(Use cells A6 to C11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the “sample” Excel formulas.)
Output area:
Asset X:
Average return
Variance
Standard deviation
Asset Y:
Average return
Variance
Standard deviation
Chapter 24 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Similar questions
- A1 fr Chapter 10: Applying Excel A В D E F 1 Chapter 10: Applying Excel 3 Data 4 Exhibit 10-1: Standard Cost Card Standard Quantity 2.9 pounds 5 Inputs Standard Price 6 Direct materials 7 Direct labor 8 Variable manufacturing overhead $4.00 per pound $22.00 per hour $6.00 per hour 0.60 hours 0.60 hours 9. 10 Actual results: Actual output Actual variable manufacturing overhead cost 13 2,000 units $7,140 Actual Quantity 6,500 pounds 11 12 Actual price $3.80 per pound $21.60 per hour 14 Actual direct materials cost 15 Actual direct labor cost 1,050 hours 16 17 Enter a formula into each of the cells marked with a ? below 18 Main Example: Chapter 10 19 20 Exhibit 10-4: Standard Cost Variance Analysis- Direct Materials 21 Standard Quantity Allowed for the Actual Output, at Standard Price 22 Actual Quantity of Input, at Standard Price 23 Actual Quantity of Input, at Actual Price 24 Direct materials variances: ? pounds x ? pounds x ? pounds x ? per pound = ? per pound = ? per pound = 25…arrow_forwardConsider the following time series: Construct a time series plot. What type of pattern exists in the data? Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. What is the forecast for t = 8?arrow_forwardExpected return and standard deviation. Use the following information to answer the questions: a. What is the expected return of each asset? b. What is the variance of each asset? c. What is the standard deviation of each asset? Hint: Make sure to round all intermediate calculations to at least seven (7) decimal places. The input instructions, phra answers you will type. Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Return on Asset A in State of Economy Boom Normal Recession Probability of State 0.35 0.51 0.14 Print State 0.05 0.05 0.05 Done Return on Asset B in State 0.23 0.08 -0.05 Return on Asset C in State 0.33 0.17 -0.22arrow_forward
- Consider the following two sets of data: A = [0.5, -0.6, 0.1, 10] & B = [6, 4, 4.5, 5.5]. Which data set will have the greatest variance?arrow_forwardCompute for expected return, variance at SD. Identify the efficient set using graph. Show solutions.arrow_forwardClose the PRIMEVAR4 file and open PRIMEVAR3. Click the Chart sheet tab. On the screen is a graphical representation of the variances computed in requirement 3. Review the chart and answer the following questions: a. Which variances does each bar represent? A __________ B __________ C __________ D __________ b. Which of the variances shown would be of most concern to management for immediate attention? (Consider groups of variances and materiality also.) Explain. When the assignment is complete, close the file without saving it again. Worksheet. McGrade Industries also has the following information regarding overhead for October: actual overhead 375,000, standard variable overhead of 3 per direct labor hour, and standard fixed overhead of 5 per direct labor hour (based on 47,000 hours budgeted). Modify the PRIMEVAR3 worksheet to compute all appropriate overhead variances. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as PRIMEVART. Hint: Insert several new rows in the Data Section and in the Answer Section. Chart. Using the PRIMEVAR3 file, prepare a 3-D stacked bar chart to compare total standard cost per unit with actual cost per unit. Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. You do not need to use cell references when completing the table. Enter all appropriate titles, legends, and formats. Enter your name somewhere on the chart. Save the file again as PRIMEVAR3. Print the chart.arrow_forward
- A diagram showing interrelationships between two or more variables is called a __________. Multiple Choice histogram variance analysis pivottable grapharrow_forwardSHOW YOUR WORK IN THE SPACES PROVIDED BELOW FOR FULL CREDIT. Properties of Normal Distribution: (3p) Write the word or phrase that best completes each statement or answers the question. a. What is the total area under the normal curve? b. The normal distribution is defined by two parameters. What are they? c. What are the mean and standard deviation of the standard normal distribution?arrow_forwardb. Convert the Data available into a Table and choose a Design of your choice.c. Obtain the Mean, Median, Standard Deviation, Variance, Quartiles (Q1, Q2, Q3, Q4), IQRfor the entire data (1895-1998), using ONLY Excel Functions (not using the Analysis ToolPak Add-In)d. Use the Statistical measurements generated from the Analysis Toolpak (Add-In) andcompare the values obtained in (c). Comment on your findings.arrow_forward
- Define the following terms, using graphs or equations to illustrate youranswers wherever feasible: d. Characteristic line; beta coefficient, barrow_forwardConsider the following utility function: u = 400 (1 + 1)−1. xy a. Is this utility function homogenous? Briefly explain. b. Use implicit differentiation to find the MRCS. c. Write down an expression for the indifference curve if u = 20.arrow_forwardOne of the assumptions made in simple regression is that ______________. Group of answer choices the error terms are exponentially distributed the error terms have unequal variances the model is linear the error terms are dependent the model is nonlineararrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning