Using the date set in the Excel file called Excel Assignment

1 calculate the cost equation using both the Hi-Low Method and the

Least-Squares Regression method. You

completed Excel workbook will contain three worksheets titled: Data,

Scattergraph, and Regression.

Submit the assignment as an Excel workbook using the name Excel Assignment 1_Your Last

Name in the Assignmnets section of our Canvas course site.

Data Worksheet Requirements

Using the Hi-Low Method, compute the Cost

Equation for the data (fixed and variable cost need only be displayed to two

decimal placed)All work must be shown and clearly labeled.All entries except the Cost Equation must be done

using cell referencing or formulas.You must use the Excel MIN and MAX functions.Enter a header with the following informationYour Name (left aligned)Excel Assignment 1 (centered)Page x of x pages (Where the first x is the page

number and the second x is the total number of pages in the workbook. Note that

both x’s must be entered as variables.) (right aligned)

Scattergraph Worksheet Requirements

Graph must contain the following elementsTitleX and Y Axis LabelsTreadline extended to Y interceptRegression EquationR2ValueExtra credit given for outstanding chart design.

(This means going beyond the default scattergraph settings and making the graph

look really nice.)

If you need help with preparing scattergraphs here’s a link

to a YouTube video:

Regression Worksheet

Format worksheet to print on one page (no

scaling) using landscape orientation.Adjust column widths so all text is displayed in

cells properly (no overlap of text between cells)Enter the Cost Equation based on the regression

analysis in cell A20

Using the date set in the Excel file called Excel Assignment

1 calculate the cost equation using both the Hi-Low Method and the

Least-Squares Regression method. You

completed Excel workbook will contain three worksheets titled: Data,

Scattergraph, and Regression.

Submit the assignment as an Excel workbook using the name Excel Assignment 1_Your Last

Name in the Assignmnets section of our Canvas course site.

Data Worksheet Requirements

Using the Hi-Low Method, compute the Cost

Equation for the data (fixed and variable cost need only be displayed to two

decimal placed)All work must be shown and clearly labeled.All entries except the Cost Equation must be done

using cell referencing or formulas.You must use the Excel MIN and MAX functions.Enter a header with the following informationYour Name (left aligned)Excel Assignment 1 (centered)Page x of x pages (Where the first x is the page

number and the second x is the total number of pages in the workbook. Note that

both x’s must be entered as variables.) (right aligned)

Scattergraph Worksheet Requirements

Graph must contain the following elementsTitleX and Y Axis LabelsTreadline extended to Y interceptRegression EquationR2ValueExtra credit given for outstanding chart design.

(This means going beyond the default scattergraph settings and making the graph

look really nice.)

If you need help with preparing scattergraphs here’s a link

to a YouTube video:

Regression Worksheet

Format worksheet to print on one page (no

scaling) using landscape orientation.Adjust column widths so all text is displayed in

cells properly (no overlap of text between cells)Enter the Cost Equation based on the regression

analysis in cell A20

Using the date set in the Excel file called Excel Assignment

1 calculate the cost equation using both the Hi-Low Method and the

Least-Squares Regression method. You

completed Excel workbook will contain three worksheets titled: Data,

Scattergraph, and Regression.

Submit the assignment as an Excel workbook using the name Excel Assignment 1_Your Last

Name in the Assignmnets section of our Canvas course site.

Data Worksheet Requirements

Using the Hi-Low Method, compute the Cost

Equation for the data (fixed and variable cost need only be displayed to two

decimal placed)All work must be shown and clearly labeled.All entries except the Cost Equation must be done

using cell referencing or formulas.You must use the Excel MIN and MAX functions.Enter a header with the following informationYour Name (left aligned)Excel Assignment 1 (centered)Page x of x pages (Where the first x is the page

number and the second x is the total number of pages in the workbook. Note that

both x’s must be entered as variables.) (right aligned)

Scattergraph Worksheet Requirements

Graph must contain the following elementsTitleX and Y Axis LabelsTreadline extended to Y interceptRegression EquationR2ValueExtra credit given for outstanding chart design.

(This means going beyond the default scattergraph settings and making the graph

look really nice.)

If you need help with preparing scattergraphs here’s a link

to a YouTube video:

Regression Worksheet

Format worksheet to print on one page (no

scaling) using landscape orientation.Adjust column widths so all text is displayed in

cells properly (no overlap of text between cells)Enter the Cost Equation based on the regression

analysis in cell A20

1 calculate the cost equation using both the Hi-Low Method and the

Least-Squares Regression method. You

completed Excel workbook will contain three worksheets titled: Data,

Scattergraph, and Regression.

Submit the assignment as an Excel workbook using the name Excel Assignment 1_Your Last

Name in the Assignmnets section of our Canvas course site.

Using the Hi-Low Method, compute the Cost

Equation for the data (fixed and variable cost need only be displayed to two

decimal placed)All work must be shown and clearly labeled.All entries except the Cost Equation must be done

using cell referencing or formulas.You must use the Excel MIN and MAX functions.Enter a header with the following informationYour Name (left aligned)Excel Assignment 1 (centered)Page x of x pages (Where the first x is the page

number and the second x is the total number of pages in the workbook. Note that

both x’s must be entered as variables.) (right aligned)

Scattergraph Worksheet Requirements

Graph must contain the following elementsTitleX and Y Axis LabelsTreadline extended to Y interceptRegression EquationR2ValueExtra credit given for outstanding chart design.

(This means going beyond the default scattergraph settings and making the graph

look really nice.)

If you need help with preparing scattergraphs here’s a link

to a YouTube video: