Hello, I would please like help on what formulas I must enter. Thanks in advance!

Instructions I would suggest reviewing Chapter 8 before attempting the assignment. This assignment requires working with SUMIF, AVERAGEIF, and COUNTIE. In addition, you will need to have an understanding of statistical functions QUARTILE.EXC. Remove my name and replace it with yours Remember, a date function at the bottom of your spreadsheet (anywhere is fine.) Attachments Assignment 5 Instruction Chapter 8 solution pdf a Statistics Spreadsheet.xlsx Quartiles Quartiles Total Sales $ 564,103 $ 1,154,422 2,064,113 YOUR NAME Date Function Summary Statistics Intro Intro General Total Sales $ 17,876,251 $ 11,198,548 Average S 1.489,688 $ 2,239,710 of pokes 12 5 es ses: Rank Discipline Introductory Aping/Death Race/Class/Gender Introductory Research/Stats Research/Stats Race/Gender Social Psychology Introductory Criminal Justice Social Psychology Research/Stats Aging/uth Sociwychology Family Social Problems Research/Mats introductory R/C/Gender Rate/Clasander cectas/Gender Research Stats Criminale Introductory Area General Death and Dying Race/Ethnicity General Research Methods Social Statistics Gender Issues General General Deviance General Social Statistics Death and Dying Symbolic interactionism Family Interaction General Research Methods Social Sciences Gender Issues Facethodity Gender Research Methods Dance Social Sciences Total Book Book Title ition holesale Retail Sales Contemporary Sociology 3,740,000 130,000 $ 3,870,000 interpretations in Grief and loss 53,564,00 187,187 $ 3,751,187 Bridging the Gap in Racial Groups 0 53,218,75 201,1425 3419,89 Sociology: An Introduction 8 $ 3,055 294,500 5 3,346 30 $ 3,0 755 226,688 $ 3,243 8 Research SUNIF $ 0,875 S 3.1 810 202,935 5 5 73,750 S 169,000 2.750 Function is Social Psychol 1 1988,0453 127,950 $ 15,995 Required in 8 2,724,777 $ 79,335 804,112 9 2.512,500 $ 280,849 2.793,349 An introduction to Symbolism $ 2,531,250 $ 180,00 2,211,298 Behavioral and Social Sciyatistics $ 2,569,675$ 109 2,679,475 Death in Society 52,625,000 $ 1 S 2,641.851 Symbolic interact An introduction $ 2,368,750 $ 2638,352 On 52 2,388,62 AVERAGEIF COUNTIF $2 RANKAVG 2352,200 Resea 52 2,351.660 Function is Function is Function is Science $ 2 2316.896 Required in Land Wool Required in 52 Required in 2,314.992 Cell F4 & 64 and that Cell F5 & G5 32 Column 2.154,250 Gender S 2083.950 Qualitative Research for Social Sciences 5 1.27500 130,000 2.057.500 Det har . S1859,000 $ 100.000 27028,000 Introduction to Social Sciences 2 $ 2,017.8203 5.2655 20225 VAD 1 2 3 4 5 6 2 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A few functions you will need to insert in completing this assignment: addition SUMIF = is a range of cells that you want evaluated by criteria. The criteria can be described in the form of a number, expression or text that defines which cells will be added. For example, criteria can be expressed as 32,"32",">32", or even "apples". I AVERAGEIF = is the range of cells that you want to average Cells in range must contain numbers, name array, or cell reference that contain numbers Cells in range that contain TRUE or FALSE are ignored If range contains blank cells or cells containing text values - AVERAGEIF will return the #Div/O! Error-value! If the cell in criteria is empty...it will return a zero value. . . COUNTIF = is known for range.criteria . . Range is the range of cells from which you want to count cells Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. Examples: #COUNTIF (A2:A5,"apples") Number of cells with apples in the first column above (2) -COUNTIF (A2:A5, A4) Number of cells with peaches in the first column above (1) . . numbers Cells in range that contain TRUE or FALSE are ignored If range contains blank cells or cells containing text values - AVERAGEIF will return the #Div/01 Error-value! If the cell in criteria is empty..it will return a zero value. COUNTIF = is known for range.criteria I Range is the range of cells from which you want to count cells Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. Examples: COUNTIF (A2:A5,"apples") Number of cells with apples in the first column above (2) =COUNTIF (A2:A5, A4) Number of cells with peaches in the first column above (1) . -COUNTIF(A2:A5, A3)+COUNTIF Number of cells with (A2:A5,A2) oranges or apples in the first column above (3) . O GS D H A 1 Quartiles Total Sales 2 Quartiles 1 G Summary Statistics Intro Intro-General Total Sales Average Sales w of Books Name Date Function 3 4 5 6 Total Book Sales Rank 7 Discipline Area 8. Introductory General 9. Aging/Death Death and Dying 10 Race/Class/Gender Race/Ethnicity 11 Introductory General 12 Research/Stats Research Methods 13 Research/stats Social Statistics 14 Race/Class/Gender Gender issues 15 Social Psychology General 16 Introductory General 17 Criminal Justice Deviance 18 Social Psychology General 19 Research/Stats Social Statistics 20 Aging/Death Death and Dying 21 Social Psychology Symbolic interactionism Books Summary Book Title Contemporary Sociology Interpretations in Grief and Loss Bridging the Gap in Racial Groups Sociology: An Introduction Researching in Social Sciences Introductory Statistics in Social Research Gender Roles in Society Modern Perspectives on Social Psychology Sociology 101 Deviant Behavior An Introduction to Symbolic interactionism Behavioral and Social Sciences Statistics Death in Society Symbolic interactionism: An Introduction Sales: Sales: Edition Wholesale Retail 1 $ 3,740,000 $ 130,000 7 $ 1,564,000 $ 187,187 10 S 3,218,750 $ 201,142 8 $ 3,051,665 $ 294,500 10 $ 3,036,5755 226,6 8 $ 2,945,875 S 202.935 5 $ 2,971,750 169,000 1 $ 2.988,0455 127.950 8 $ 2,724,777 $ 79,335 9 $ 2,512,500 $ 280 349 5 52,531,250 150,00 6 $ 2.569,63 109 1100 2 S 2.025.000 16,051 > $ 2,361,750 209.602 AchoSave Search CH Statistici Spreadshart. Scal Fle General Home Page Layout Formulas Data Review View Help Can 1. AN = 13 Wrap Test BIU-- A-Merye & Center - $ -% a Conditional formata Formang. Tible Styles Pante Numb Alignment Cipboard GS > D 2 2 10 10 9 10 8 10 5 6 1 4 20 Agine/Death Death and Dying Death in Society 21 Social Psycholoty Symbolic interactionism Symbolic Interactionism: An Introduction 22 Family Family Interaction Trends in Family Interactions 21 Social Problems General Current Social Problems 24 Research/stats Research Methods Quantitative and Qualitative Research Methods 25 introductory Social Sciences Modern Approach to Social Science 26 Race/class/Gender Gender Hues Social Constructs for Men and Women 27. Race/class/Gender Race/ethnicity America Diversity in Race and Ethnicity 20 Race/class/Gender Gender Sociological perspectives on Gender 29 Research/stats Research Methods Qualitative Research for Social Sciences 30 Criminal Justice Deviance Devin Behavior 31 Introductory Social Sciences Introduction to Social Sciences 12 Social Problems Violence Abuse Increasing Violence in Our Schools 13 Race/class/Gender Human Sexuality Human Sexuality 14 Social Psychology General Social Psychology 15 Miscellaneous Social Theory Modern Sociological Theories 10 Race/Clas/ender Genders Introduction to Gender issues af Aging/Death Death and bring Human Anand Death 30 Family Marriage and Family Marriages and Family Matters 39 Sool Psychology Symbol teraction Symbolic interaction info A Social Problems General Social problem Social Statistics Procedures for social $ 2,025,000 $ 16,651 $2,7505 26 5.2.187.500 5 201,142 5 2,54,500 5 17,700 $ 2,111,100 $ 40,500 5 2.230.750 S 22,140 5 2.247.600 $ 67,19 5 2,127,500 5 36,50 $ 2,000,000 11,550 5 1.127,500 5 130,000 5 1359,000 $ 109,000 $ 2,017,6005 5.265 51.9,6205 11.590 5 18045505 132.300 $1,622,0653 050 $ 000 5 213,000 5 1.61255 231.200 $ 1.750 1270 $ 14042505 5 1457,960S $1,431.00 12.00 $ 1,411 2 5 1 5 5 2 Boo Summary BI Type bele towards Instructions I would suggest reviewing Chapter 8 before attempting the assignment. This assignment requires working with SUMIF, AVERAGEIF, and COUNTIE. In addition, you will need to have an understanding of statistical functions QUARTILE.EXC. Remove my name and replace it with yours Remember, a date function at the bottom of your spreadsheet (anywhere is fine.) Attachments Assignment 5 Instruction Chapter 8 solution pdf a Statistics Spreadsheet.xlsx Quartiles Quartiles Total Sales $ 564,103 $ 1,154,422 2,064,113 YOUR NAME Date Function Summary Statistics Intro Intro General Total Sales $ 17,876,251 $ 11,198,548 Average S 1.489,688 $ 2,239,710 of pokes 12 5 es ses: Rank Discipline Introductory Aping/Death Race/Class/Gender Introductory Research/Stats Research/Stats Race/Gender Social Psychology Introductory Criminal Justice Social Psychology Research/Stats Aging/uth Sociwychology Family Social Problems Research/Mats introductory R/C/Gender Rate/Clasander cectas/Gender Research Stats Criminale Introductory Area General Death and Dying Race/Ethnicity General Research Methods Social Statistics Gender Issues General General Deviance General Social Statistics Death and Dying Symbolic interactionism Family Interaction General Research Methods Social Sciences Gender Issues Facethodity Gender Research Methods Dance Social Sciences Total Book Book Title ition holesale Retail Sales Contemporary Sociology 3,740,000 130,000 $ 3,870,000 interpretations in Grief and loss 53,564,00 187,187 $ 3,751,187 Bridging the Gap in Racial Groups 0 53,218,75 201,1425 3419,89 Sociology: An Introduction 8 $ 3,055 294,500 5 3,346 30 $ 3,0 755 226,688 $ 3,243 8 Research SUNIF $ 0,875 S 3.1 810 202,935 5 5 73,750 S 169,000 2.750 Function is Social Psychol 1 1988,0453 127,950 $ 15,995 Required in 8 2,724,777 $ 79,335 804,112 9 2.512,500 $ 280,849 2.793,349 An introduction to Symbolism $ 2,531,250 $ 180,00 2,211,298 Behavioral and Social Sciyatistics $ 2,569,675$ 109 2,679,475 Death in Society 52,625,000 $ 1 S 2,641.851 Symbolic interact An introduction $ 2,368,750 $ 2638,352 On 52 2,388,62 AVERAGEIF COUNTIF $2 RANKAVG 2352,200 Resea 52 2,351.660 Function is Function is Function is Science $ 2 2316.896 Required in Land Wool Required in 52 Required in 2,314.992 Cell F4 & 64 and that Cell F5 & G5 32 Column 2.154,250 Gender S 2083.950 Qualitative Research for Social Sciences 5 1.27500 130,000 2.057.500 Det har . S1859,000 $ 100.000 27028,000 Introduction to Social Sciences 2 $ 2,017.8203 5.2655 20225 VAD 1 2 3 4 5 6 2 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A few functions you will need to insert in completing this assignment: addition SUMIF = is a range of cells that you want evaluated by criteria. The criteria can be described in the form of a number, expression or text that defines which cells will be added. For example, criteria can be expressed as 32,"32",">32", or even "apples". I AVERAGEIF = is the range of cells that you want to average Cells in range must contain numbers, name array, or cell reference that contain numbers Cells in range that contain TRUE or FALSE are ignored If range contains blank cells or cells containing text values - AVERAGEIF will return the #Div/O! Error-value! If the cell in criteria is empty...it will return a zero value. . . COUNTIF = is known for range.criteria . . Range is the range of cells from which you want to count cells Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. Examples: #COUNTIF (A2:A5,"apples") Number of cells with apples in the first column above (2) -COUNTIF (A2:A5, A4) Number of cells with peaches in the first column above (1) . . numbers Cells in range that contain TRUE or FALSE are ignored If range contains blank cells or cells containing text values - AVERAGEIF will return the #Div/01 Error-value! If the cell in criteria is empty..it will return a zero value. COUNTIF = is known for range.criteria I Range is the range of cells from which you want to count cells Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. Examples: COUNTIF (A2:A5,"apples") Number of cells with apples in the first column above (2) =COUNTIF (A2:A5, A4) Number of cells with peaches in the first column above (1) . -COUNTIF(A2:A5, A3)+COUNTIF Number of cells with (A2:A5,A2) oranges or apples in the first column above (3) . O GS D H A 1 Quartiles Total Sales 2 Quartiles 1 G Summary Statistics Intro Intro-General Total Sales Average Sales w of Books Name Date Function 3 4 5 6 Total Book Sales Rank 7 Discipline Area 8. Introductory General 9. Aging/Death Death and Dying 10 Race/Class/Gender Race/Ethnicity 11 Introductory General 12 Research/Stats Research Methods 13 Research/stats Social Statistics 14 Race/Class/Gender Gender issues 15 Social Psychology General 16 Introductory General 17 Criminal Justice Deviance 18 Social Psychology General 19 Research/Stats Social Statistics 20 Aging/Death Death and Dying 21 Social Psychology Symbolic interactionism Books Summary Book Title Contemporary Sociology Interpretations in Grief and Loss Bridging the Gap in Racial Groups Sociology: An Introduction Researching in Social Sciences Introductory Statistics in Social Research Gender Roles in Society Modern Perspectives on Social Psychology Sociology 101 Deviant Behavior An Introduction to Symbolic interactionism Behavioral and Social Sciences Statistics Death in Society Symbolic interactionism: An Introduction Sales: Sales: Edition Wholesale Retail 1 $ 3,740,000 $ 130,000 7 $ 1,564,000 $ 187,187 10 S 3,218,750 $ 201,142 8 $ 3,051,665 $ 294,500 10 $ 3,036,5755 226,6 8 $ 2,945,875 S 202.935 5 $ 2,971,750 169,000 1 $ 2.988,0455 127.950 8 $ 2,724,777 $ 79,335 9 $ 2,512,500 $ 280 349 5 52,531,250 150,00 6 $ 2.569,63 109 1100 2 S 2.025.000 16,051 > $ 2,361,750 209.602 AchoSave Search CH Statistici Spreadshart. Scal Fle General Home Page Layout Formulas Data Review View Help Can 1. AN = 13 Wrap Test BIU-- A-Merye & Center - $ -% a Conditional formata Formang. Tible Styles Pante Numb Alignment Cipboard GS > D 2 2 10 10 9 10 8 10 5 6 1 4 20 Agine/Death Death and Dying Death in Society 21 Social Psycholoty Symbolic interactionism Symbolic Interactionism: An Introduction 22 Family Family Interaction Trends in Family Interactions 21 Social Problems General Current Social Problems 24 Research/stats Research Methods Quantitative and Qualitative Research Methods 25 introductory Social Sciences Modern Approach to Social Science 26 Race/class/Gender Gender Hues Social Constructs for Men and Women 27. Race/class/Gender Race/ethnicity America Diversity in Race and Ethnicity 20 Race/class/Gender Gender Sociological perspectives on Gender 29 Research/stats Research Methods Qualitative Research for Social Sciences 30 Criminal Justice Deviance Devin Behavior 31 Introductory Social Sciences Introduction to Social Sciences 12 Social Problems Violence Abuse Increasing Violence in Our Schools 13 Race/class/Gender Human Sexuality Human Sexuality 14 Social Psychology General Social Psychology 15 Miscellaneous Social Theory Modern Sociological Theories 10 Race/Clas/ender Genders Introduction to Gender issues af Aging/Death Death and bring Human Anand Death 30 Family Marriage and Family Marriages and Family Matters 39 Sool Psychology Symbol teraction Symbolic interaction info A Social Problems General Social problem Social Statistics Procedures for social $ 2,025,000 $ 16,651 $2,7505 26 5.2.187.500 5 201,142 5 2,54,500 5 17,700 $ 2,111,100 $ 40,500 5 2.230.750 S 22,140 5 2.247.600 $ 67,19 5 2,127,500 5 36,50 $ 2,000,000 11,550 5 1.127,500 5 130,000 5 1359,000 $ 109,000 $ 2,017,6005 5.265 51.9,6205 11.590 5 18045505 132.300 $1,622,0653 050 $ 000 5 213,000 5 1.61255 231.200 $ 1.750 1270 $ 14042505 5 1457,960S $1,431.00 12.00 $ 1,411 2 5 1 5 5 2 Boo Summary BI Type bele towards