Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Login


Options
Go to last post Go to first unread
Offline Marcela T  
#1 Posted : 17 June 2021 23:18:05(UTC)
Marcela T


Rank: Member

Groups: Registered
Joined: 13/05/2021(UTC)
Posts: 12
Woman
Colombia
Location: MEDELLIN

hi...I need find the average of each row (without include the first number) and at the end find the average of all averages....thanks for the help

average.PNG

Wanna join the discussion?! Login to your SMath Studio Forum forum account. New Registrations are disabled.

Offline Jean Giraud  
#2 Posted : 17 June 2021 23:41:50(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,868
Canada

Was thanked: 980 time(s) in 808 post(s)
Had you attached the table ... job done.
Cheers ... Jean

Average.PNG
Offline overlord  
#3 Posted : 17 June 2021 23:47:26(UTC)
overlord


Rank: Advanced Member

Groups: Registered
Joined: 23/07/2013(UTC)
Posts: 1,124
Turkey

Was thanked: 506 time(s) in 337 post(s)
Originally Posted by: Marcela T Go to Quoted Post
hi...I need find the average of each row (without include the first number) and at the end find the average of all averages....thanks for the help

Long version

2021-06-17_23-46.png

Short version

2021-06-17_23-53.png

Edited by user 17 June 2021 23:54:27(UTC)  | Reason: Not specified

Offline Jean Giraud  
#4 Posted : 18 June 2021 14:02:29(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,868
Canada

Was thanked: 980 time(s) in 808 post(s)
Originally Posted by: Jean Giraud Go to Quoted Post
Had you attached the table ... job done.


Average.sm (10kb) downloaded 21 time(s).
Offline mkraska  
#5 Posted : 18 June 2021 14:07:34(UTC)
mkraska


Rank: Advanced Member

Groups: Registered
Joined: 15/04/2012(UTC)
Posts: 1,980
Germany

Was thanked: 1120 time(s) in 718 post(s)
Another version with scalar product.
Easy to adjust to arbitrary subsets of columns.

avg.png
avg.sm (7kb) downloaded 17 time(s).

Martin Kraska

Pre-configured portable distribution of SMath Studio: https://smath.com/wiki/SMath_with_Plugins.ashx
thanks 1 user thanked mkraska for this useful post.
on 18/06/2021(UTC)
Users browsing this topic
Similar Topics
Average If function (Questions)
by gth802s 28/12/2023 09:55:01(UTC)
How to calculate average reading the entries of a Table (Questions)
by Basile 28/01/2021 20:43:22(UTC)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.