i would like to create this variable: piracy rate

$/$

$1$

$-$

piracy rate either in an Excel sheet or directly in R

$,$

$$programing$,$ then you take the log of it

$.$

$$to produce a table like table

$4$

$$which is attached with exact information in R programming. can you provide me the steps both in R programming and excel. my data are as follows: PIR COL INC COST INT PIR

$($

$4$

$5$

$,$

$3$

$0$

$,$

$4$

$0$

$,$

$7$

$5$

$,$

$9$

$5$

$,$

$1$

$5$

$,$

$2$

$0$

$,$

$6$

$0$

$,$

$9$

$2$

$,$

$4$

$0$

$,$

$1$

$5$

$,$

$2$

$0$

$,$

$5$

$0$

$,$

$7$

$0$

$,$

$9$

$5$

$,$

$7$

$5$

$,$

$8$

$5$

$,$

$4$

$0$

$,$

$4$

$0$

$,$

$4$

$0$

$,$

$2$

$5$

$,$

$1$

$5$

$,$

$2$

$0$

$,$

$6$

$0$

$,$

$4$

$5$

$,$

$5$

$0$

$)$

$,$

$$COL

$($

$5$

$4$

$,$

$6$

$2$

$,$

$7$

$7$

$,$

$8$

$7$

$,$

$9$

$2$

$,$

$6$

$5$

$,$

$7$

$5$

$,$

$5$

$2$

$,$

$8$

$6$

$,$

$4$

$6$

$,$

$2$

$4$

$,$

$8$

$2$

$,$

$7$

$4$

$,$

$7$

$0$

$,$

$8$

$6$

$,$

$8$

$4$

$,$

$6$

$8$

$,$

$6$

$2$

$,$

$8$

$0$

$,$

$3$

$5$

$,$

$4$

$9$

$,$

$2$

$9$

$,$

$3$

$2$

$,$

$8$

$0$

$,$

$6$

$3$

$,$

$8$

$8$

$)$

$,$

$$INC

$($

$6$

$8$

$4$

$1$

$,$

$4$

$6$

$4$

$1$

$,$

$5$

$4$

$4$

$1$

$,$

$2$

$2$

$7$

$5$

$,$

$1$

$7$

$9$

$5$

$,$

$1$

$4$

$1$

$6$

$2$

$,$

$2$

$5$

$4$

$5$

$5$

$,$

$4$

$9$

$3$

$,$

$1$

$0$

$6$

$0$

$,$

$1$

$6$

$6$

$7$

$5$

$,$

$2$

$1$

$3$

$9$

$5$

$.$

$1$

$4$

$9$

$3$

$6$

$,$

$4$

$8$

$1$

$0$

$,$

$3$

$7$

$2$

$0$

$,$

$5$

$2$

$0$

$,$

$2$

$3$

$7$

$9$

$,$

$1$

$2$

$0$

$8$

$,$

$7$

$5$

$6$

$2$

$,$

$2$

$7$

$5$

$3$

$2$

$,$

$4$

$2$

$0$

$1$

$,$

$1$

$8$

$0$

$5$

$0$

$,$

$3$

$3$

$6$

$6$

$4$

$,$

$4$

$6$

$5$

$5$

$3$

$,$

$3$

$0$

$0$

$0$

$,$

$2$

$9$

$4$

$6$

$,$

$2$

$9$

$7$

$7$

$$COST

$($

$8$

$.$

$5$

$,$

$2$

$.$

$4$

$,$

$1$

$4$

$.$

$7$

$,$

$5$

$.$

$9$

$,$

$1$

$0$

$.$

$5$

$,$

$8$

$.$

$2$

$,$

$6$

$.$

$9$

$,$

$2$

$2$

$2$

$.$

$3$

$,$

$3$

$8$

$6$

$.$

$2$

$,$

$3$

$4$

$.$

$1$

$,$

$3$

$.$

$9$

$,$

$4$

$.$

$5$

$,$

$2$

$,$

$1$

$0$

$,$

$4$

$5$

$.$

$8$

$,$

$2$

$9$

$.$

$7$

$,$

$1$

$0$

$3$

$.$

$7$

$,$

$0$

$,$

$1$

$.$

$9$

$,$

$6$

$1$

$.$

$6$

$,$

$1$

$0$

$.$

$7$

$,$

$7$

$.$

$6$

$,$

$3$

$.$

$9$

$,$

$1$

$.$

$4$

$,$

$5$

$.$

$4$

$,$

$4$

$6$

$.$

$9$

$)$

$,$

$$INT

$($

$1$

$1$

$2$

$,$

$8$

$2$

$,$

$2$

$3$

$7$

$,$

$4$

$6$

$,$

$4$

$1$

$,$

$1$

$5$

$4$

$,$

$4$

$3$

$0$

$,$

$1$

$5$

$,$

$3$

$7$

$,$

$3$

$0$

$1$

$,$

$3$

$5$

$2$

$,$

$5$

$5$

$1$

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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 Databases Questions!

Q:

i would like to create this variable: piracy rate / 1 - piracy rate either in an Excel sheet or directly in R , programing, then you take the log of it . to produce a table like table 4 which is...

Q:

i would like to create this variable: piracy rate / 1 - piracy rate either in an Excel sheet or directly in R , programing, then you take the log of it . to produce a table like table 4 which is...

Q:

i would like to create this variable: piracy rate / 1 - piracy rate either in an Excel sheet or directly in R , programing, then you take the log of it . to produce a table like table 4 which is...

Q:

Instruction is in the file. You need to do it in excel. I need the answers in 2 hours. Section 2 Data Part A Figuring out how to get data to run regressions. A friend tells you that you should invest...

Q:

GoodCoffee is a coffee product retailer and manufacturer located in Irvine, CA. The company president is Josh Ryan, who inherited the company. When the company was founded over 50 years ago, it...

Q:

PLEASE SHOW ALL WORK Coug Coffee is an American coffee product retailer and manufacturer located in Pullman, WA. The company president is Jack Ryan, who inherited the company. When the company was...

Q:

CougCoffee is an American coffee product retailer and manufacturer located in Pullman, WA. The company president is Jack Ryan, who inherited the company. When the company was founded over 50 years...

Q:

Joy Toys is a midsized Toy manufacturer located in Manhattan, New York. The company president is George, who inherited the company. When it was founded over 50 years ago, the company originally was a...

Q:

Fun Toys spent $650,000 to develop a prototype for a new baby doll that has all the features of the existing baby doll but adds new features such as an AI system, much like Apples Siri or Amazons...

Q:

You have an opportunity to buy the Newton Falls Paper mill for $15 million. Currently the mill sells standard paper reams and revenues total $6 million per year with fixed costs of $2 million and...

Q:

In this assignment, draft the letter for the signature of the supervising attorney, Alice Black. Use the letterhead presented in the Application section of this chapter. Mr. Sanderss address is 930...

Q:

Read the article titled Key Person Insurance a Cash Flow Puzzle located in Week 9 of the online course shell You may also view the article at http www3 cfo com article 2012 4 cash flow free cash flow...

Q:

What is the main idea of Registered Retirement Savings Plan ( RRSP ) Canada? Pay less income tax now Accrue Tax - free investments to purchase a home Accrue Tax - free investments for education Save...

Q:

An engaging and convincing strategic vision a . ought to put "who we are and what we are doing" in writing rather than orally so as to leave no room for company personnel to misinterpret what the...

Q:

3. If you were an MWEB customer, would you consider MWEBs response to the security breach to be acceptable? Why or why not? BMWEB, launched in 1997, became South Africas leading ISP in 1998. It has...

Q:

3. What makes Stuxnet different from other cyberwarfare attacks? How serious a threat is this technology? In July 2010, reports surfaced about a Stuxnet worm that had been targeting Irans nuclear...

Q:

1. What technology issues led to the security breach at MWEB? BMWEB, launched in 1997, became South Africas leading ISP in 1998. It has established itself as a company that provides a cutting-edge...

Previous Question Next Question