really really neeeeeeeeed help with this, how to and examples etc. I'm wiling to talk about higher price if the right persons helps. Teacher is no help at allllll!!!

Your first Excel Problem Set involves taking mixed costs and separating them into their variable and fixed components. You will use the Hi-Low method, a scatter graph, and Regression Analysis, and then compare the results. Complete instructions are given in the following file: A-202 Excel Regression Analysis Assignment Instructions.pdf The data you need to complete this assignment can be found in the following file: A-202 Excel Regression Analysis Assignment Data.xlsx Follow the instructions carefully. I expect your submission to be both accurate and professional. Be sure to spend time properly formatting your file, checking your spelling, etc. Think of our submission as something you'd turn in to your boss. For assistance in performing the regression analysis and creating a scattergraph, please refer back to Chapter 2. Appendix 2A reviews how to use Excel to perform a regression analysis and create a scattergraph plot. You may also find the following link helpful in conducting the regression analysis. http://www.exceleasy.com/examples/regression.html (Links to an external site.) The assignment is due by Monday, October 10 at 11:59pm. I would be happy to answer any specific question regarding the assignment so please, don't leave this until the last minute! Rubric Excel Problem Set #1 - Regression Analysis Assignment Excel Problem Set #1 - Regression Analysis Assignment Criteria Excel: Formulas and Cell Linking Ratings The spreadsheet formula(s) are welldeveloped and will correctly determine the needed information. 10.0 pts The spreadsheet formula(s) will correctly determine the needed information but lacks all of the necessary cell references needed. 8.0 pts The s formu used deter inform 4.0 pt 10.0 pts Excel: Labels and Headi ngs Contain s clearly labeled rows and column s 5.0 pts Rating Descript ion 4.0 pts 5.0 pts Excel and Memo: Content Meets all requirements necessary to communicate and display the requested information for the company. 15.0 pts Includes and makes clear all but one or two minor details that are necessary. 12.0 pts Includes a clear all b four detai necessary 6.0 pts 15.0 pts Excel: Professionalism and Organization Assignment has exceptional formatting and the information is well organized and professional. Documents are visually appealing and easy to read. 10.0 pts Assignment has attractive formatting and is somewhat organized. Data can be read and interpreted, but with some difficulty. 8.0 pts Assignment is somewhat orga Readability nee improvement, is great difficul interpreting the information. 4.0 pts 10.0 pts Excel: Directions All directions were followed accurately and completely. 5.0 pts Most of the directions were followed accurately. 4.0 pts 5.0 pts Total Points: 45.0 Whitewash, Inc. produces and sells whitewash. Since the major component of their product is water, the local water company instituted a billing system whereby the company is charged a fixed fee each month plus a per gallon charge. No one in your company can figure out what the Some o directio followe 3.0 pts fixed fee is because it's not separated on the monthly bill. As the new hire you have been given the unenviable task of figuring out the fixed cost portion of the water bill and coming up with a cost equation that management can use when budgeting. Everyone thinks you're doomed to failure but you graduated from IU East and to you this project is a walk in the park. You know your boss is an Excel addict and so you want to impress him by doing your work neatly in Excel. Here's what you need to do: 1. Using the data provided, calculate the cost equation using the HiLow method. To do this, duplicate the data set in a new worksheet, convert it into a table, sort by largest to smallest water usage, and perform the calculations to arrive at the cost equation based on the HiLow method. Show and explain all your work. You need to use cell referencing, the Excel Min and Max functions, and formulas to receive full credit. Make sure to write out the cost formula that you come up with. Carry the variable cost per unit out to six decimal places and the fixed cost to two decimal places. 2. Graph the data using a scatter graph. Make sure the graph is properly labeled (title, xaxis, yaxis). Insert a trendline, making sure to extend the line so it intersects the yaxis. Insert the equation for the trendline and the R2 value on the chart. 3. Perform a regression analysis on the data. Using the results, determine the exact equation of the line and the R2 value. Carry the variable cost per unit out to six decimal places and the fixed cost to two decimal places. Make sure the data is formatted properly and will print on one sheet of paper. 4. Write a short memo to your boss (Mr. Crane) explaining what you did, which cost equation is more accurate, and why. You will turn in two files, an Excel file with all your work and a Word File with your memo. Your Excel file should have the following worksheet tabs in this order: Your Excel file should be named Regression_YOUR LAST NAME. Your Word file should contain only the memo to your boss. It should be named Regression Memo_YOUR LAST NAME. Submit the assignment through the Canvas Assignments Tool. You will be graded using the following criteria: Excel HiLow: Excel Scatter Graph: Table Formatting Computation Labels Explanation Trendline with yaxis intercept, Cost Equation, and R2 value Formatting Proper cost equation Excel Regression: Word Memo: Formatting Formatting Proper cost equation Professionalism Proper explanation