In Excel, give each column a weight percentage for the crime committed, multiply it by the corresponding crime value to get a weighted score Then add the weighted scores to get a total score I am looking for a clear explanation of the steps on how to first get the weight percent of each column, then multiply it by the corresponding value to get the weighted score, then add for a total weighted score Data ViolentCrime Murder Rape Robbery AggravatedAssault PropertyCrime Burglary Theft MotorVehicleTheft State 412 5 5 3 56 78 4 272 8 3,609 00 852 2,493 60 263 4 TX 238 4 5 1 38 2 75 2 119 8 2,552 40 575 3 1,853 00 124 1 OH 667 9 7 8 30 4 157 9 471 8 3,894 10 1,099 60 2,652 80 141 7 GA 114 3 2 5 28 2 20 7 63 3,208 40 484 6 2,476 10 247 7 OR 792 6 6 1 63 8 206 7 516 4,607 80 883 4 3,047 60 676 9 NM 936 4 4 5 35 5 120 1 776 3 4,565 90 1,167 00 3,083 70 315 2 LA 216 5 0 8 28 7 25 5 161 6 1,430 20 218 9 1,163 60 47 8 PA 538 7 3 4 72 107 1 356 1 3,827 40 763 2 2,743 20 321 TX 158 5 1 47 2 19 9 90 3 1,848 30 311 7 1,462 00 74 5 IA 1,039 50 8 2 165 6 199 1 666 6 4,030 10 554 9 3,087 50 387 7 AK 319 5 1 9 57 51 4 209 2 1,791 90 290 4 1,417 40 84 2 MI 699 3 8 7 53 9 86 550 7 3,295 80 1,012 90 2,160 40 122 5 AL 138 8 0 4 24 1 8 6 105 7 1,394 90 206 6 1,154 70 33 5 WI 202 2 7 19 5 50 2 129 7 2,158 80 592 6 1,436 60 129 7 NC 325 7 2 5 41 3 67 7 214 2 3,105 50 675 4 2,272 70 157 4 GA

The Answer is in the image, click to view ...

Question: In Excel, give each column a weight percentage for the crime committed, multiply it by the corresponding crime value to get a weighted score. Then

In Excel, give each column a weight percentage for the crime committed, multiply it by the corresponding crime value to get a weighted score. Then add the weighted scores to get a total score.

I am looking for a clear explanation of the steps on how to first get the weight percent of each column, then multiply it by the corresponding value to get the weighted score, then add for a total weighted score

Data:

ViolentCrime	Murder	Rape	Robbery	AggravatedAssault	PropertyCrime	Burglary	Theft	MotorVehicleTheft	State
412.5	5.3	56	78.4	272.8	3,609.00	852	2,493.60	263.4	TX
238.4	5.1	38.2	75.2	119.8	2,552.40	575.3	1,853.00	124.1	OH
667.9	7.8	30.4	157.9	471.8	3,894.10	1,099.60	2,652.80	141.7	GA
114.3	2.5	28.2	20.7	63	3,208.40	484.6	2,476.10	247.7	OR
792.6	6.1	63.8	206.7	516	4,607.80	883.4	3,047.60	676.9	NM
936.4	4.5	35.5	120.1	776.3	4,565.90	1,167.00	3,083.70	315.2	LA
216.5	0.8	28.7	25.5	161.6	1,430.20	218.9	1,163.60	47.8	PA
538.7	3.4	72	107.1	356.1	3,827.40	763.2	2,743.20	321	TX
158.5	1	47.2	19.9	90.3	1,848.30	311.7	1,462.00	74.5	IA
1,039.50	8.2	165.6	199.1	666.6	4,030.10	554.9	3,087.50	387.7	AK
319.5	1.9	57	51.4	209.2	1,791.90	290.4	1,417.40	84.2	MI
699.3	8.7	53.9	86	550.7	3,295.80	1,012.90	2,160.40	122.5	AL
138.8	0.4	24.1	8.6	105.7	1,394.90	206.6	1,154.70	33.5	WI
202	2.7	19.5	50.2	129.7	2,158.80	592.6	1,436.60	129.7	NC
325.7	2.5	41.3	67.7	214.2	3,105.50	675.4	2,272.70	157.4	GA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

On July 1, 2022, the first day of its 2023 fiscal year, the Town of Bear Creek issued at par $2,000,000 of 2 percent term bonds to renovate a historic wing of its main administrative building. The...

Current and historical Financial Statements (Income Statement (I/S), Balance Sheet (B/S) and Statement of Cash Flows) from the three most current years for the firm The financial statements must...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

unit II q12. Summarized on the right is the sale (in thousands) of the top five products in 2002. Use this information to calculate what percent of the sales of these five products was due to product...

c. Assign each decision variable a score based on information you gathered through research. Show these as numbers from, say, 0 to 10 , where 0 means that the factor is absolutely unimportant or has...

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

Part 1: Perform the necessary calculations as followed: Download from SimNet: CSE 2111 Pre Lab 3 Computer Budget Master.xlsx CSE 2111 Pre Lab 3 Candidates Master.alsx YOU MUST DOWNLOAD YOUR STARTING...

Jupiter Notebook We have covered some of the limitations of single layer neural networks in class, but they are still powerful learning systems that provide a good way to begin learning about how to...

Use case to answer question only you don't need no other reference. Case Overview Founded by Jeff Bezos, online giant Amazon.com, Inc. (Amazon), was incorporated in the state of Washington in July,...

Would you be able to put together another monthly cash flow analysis, this time for year 1? INCOME STATEMENT Year 1 269,115.00 48,930.00 20,388.00 338,433.00 $ $ $ $ COGS $ 113,940.00 $ 125,940.00 $...

What is the equivalent cash value of the offer in Problem 11 if the vendor financing arrangement is for the same 10-year amortization but with a. A five-year term? b. A one-year term? In Problem 11 A...

To adapt to the changing needs of society a neighborhood provision store would like to create a website. As an initial prototype help them design their site using HTML. The homepage of the site...

Suppose that a project requires an investment of $20,000, and it produces a single period cash flow of $25,000. What is the IRR of the project?

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...