What ‘Benford’s Law’ stands for?
Around 1938 Frank Benford, a physicist at the General Electrics research laboratories, observed that logarithmic tables were more worn within first pages: was this casual or due to an actual prevalence of numbers near 1 as first digits?
tags:
algorithm /analytics /data /data analysis /data analytics /internal audit /R /shiny /shiny apps /
2014
download data to excel from web
2014/10/28
This simple tutorial will show you how to download data into an excel spreadsheet, creating a web query.
Download data into excel
select “data” tab

select “from web”



**select **data you want to download


Refresh downloaded data
select “data” tab
![Image [9]](https://andreacirilloblog.files.wordpress.com/2014/10/image-9.png?w=300)
tags:
data /excel /excel spreadsheet /tutorials /web query /
excel right() function in R
2014/10/27
as part of the** excel functions in R,** I have developed this custom function, reproducing the excel right() function in th R language. Feel free to copy and use it.
[code language=“r”]
right = function (string, char){
substr(string,nchar(string)-(char-1),nchar(string))}
[/code]
you can find other function in the Excel functions in R post.
tags:
analytics /data /data analysis /data analytics /excel /excel spreadsheet /functions /R /
excel left() function in R
2014/10/27
as part of the excel functions in R, I have developed this custom function, emulating the excel left() function in th R language. Feel free to copy and use it.
left = function (string,char){
substr(string,1,char)}
you can find other function in the** Excel functions in R post**.
tags:
analytics /data /data analysis /data analytics /excel /functions /R /